No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi All, I am trying to export data from SQL Server. But i am unable to do that. I have also created an SSIS pacage and after connecting the excel Manager when I am going to select the excel sheet it shows me the following error **The 'Microsoft.ACE.OLEDB.12.0' provider is …
|
|
|
Hi All, From a table I am getting the length of character in a column. My query is below SELECT b.[file_id],b.[lineno],b.fileContent, datalength(b.fileContent) Length1 FROM FileBascContent b join filebasic on filebasic.[file_id]=b.[file_id] WHERE substring(b.fileContent,1,4) not in('VOL1','HDR1','UHL1','UTL1','HDR2','EOF1','EOF2') and filebasic.[file_id]=347 I am getting the result 98, 97 and 100 which is fine for me. … 
|
|
|
Hi All, I have 44,000 data in a table (dbo.IA_Subscription) where I have only 2 columns; one is ID and another is Magazine_Type ID filed is filled with contact_ID and Magazine_Type is filled with 3 Magazine e.g. Papaer Type, Digital Type and Web Type. Now contact_ID is not unique...one contact_ID … 
|
|
|
Hi All, In my table (dbo.partha) i have three fields. the first one is id, 2nd one is CM_Name and the last one is empid the table looks like id name empid 1 Das 5 2 Ram 9 3 Abi 5 1 Wed 5 4 Sat 4 5 Sun 3 … 
|
|
|
Hi All, In a table (dbo.UnquotedContacts) I have few columns from where I am trying to extract few columns. But My crcern is as follows IF the field 'Date_ABC_Updated' is NOT empty AND the field 'subscribed_to_Business_XL' = 'SUB', the contact has an ACTIVE BXL subscription IF the field 'Date_ABC_Updated' is … 
|
|
|
I have 82425 data in a table. through a query I fetched 73876 data in a new table. Now I want the data which I have not got from the query. My query is SELECT af.* Into IAGroupNoNGroup FROM ( SELECT Key_out, MAX(Max_FieldValue) Max_FieldValue, ( SELECT TOP 1 Key_in FROM … 
|
|
|
Hi All, I am new comer in this site. Through Google serach I have found this community. Hope this site is really helpful for the beginers who wants to learn everything However I have written a query and got the result. Now I want to insert the data (what I …
|