Hello tarekj, What version of SQL Server are you using? If that is 2005, you may use nvarchar(max) otherwise if it is versions 7 or 2000, you are...
Thanks for the input. I was actually trying to use an aggregate function "GROUPING" WITH ROLLUP operator but the result is messed up. In the...
How about using a UNION? select col.value('(ADDRESS/PHONES/TYPE)[1]', 'VARCHAR(40)' ) AS TYPEOFPHONE, col.value('(ADDRESS/PHONES/NUMBER)[1]',...
It should be under "Files Page".
What are you trying to do? Any error messages? What is the problem all about? What version is your SQL Server?
Hello All, Is it possible to achieve the below desired output, using one query only? date starttime endtime length field1...
Hi Vandana12345, You might want to try using insert into...select statement which I believe is way faster instead of inserting data using cursor....
Thank you! Yes, they are useful.
Hi All, Is it necessary to drop the symmetric key, certificate, and database master key every time we encrypt/decrypt data? Thanks, Jon M
Hello All, I will be creating 2 SSIS projects. They have similar flow for now but later on one project will change gradually (new flows will be...
Check if you have the pair "On Error Resume Next" and "On Error GoTo 0". Jon M
Maybe you can add a script that will do the following: 1. Reserve the rows by inserting X amount of rows into the destination table. When I say...
Thank you for all the replies. The temporary table rowcount varies. For example today, it can have 1M rows the following day it may have 50,000...
Hello All, I have a temporary table which I truncate everytime I run my process - the same process will then insert new records from another source...
Thanks for the reply, Sat. I got this working on SSIS using Fuzzy Lookup and Conditional Split. Jon M
Hi All, I am trying to import records from table1 to table2 but I want to exclude table1 records that are already existing on table2. If the same...
See if this will resolve your problem: http://support.microsoft.com/kb/937969 Jon M
Check this idea: http://www.sqlis.com/55.aspx Jon M
Thanks for the reply, Satya. I also got some tips from here: http://www.mssqltips.com/tip.asp?tip=1443 Jon M
With SQL Server 2000 DTS, we can dynamically change a global variable using the Dynamic Properties Task. I understand that Dynamic Properties is no...
Separate names with a comma.
