Viewing 15 posts - 10,426 through 10,440 (of 13,874 total)
JanTimmermans (9/21/2012)
I also use a cursor, but that has to stay in the procedure.
When running it from SSMS, it flies,...
September 21, 2012 at 6:13 am
siggemannen (9/20/2012)
These kind of queries have real usage, for example if you want to preserve "duplicate rows" of Col1, Col2, which cannot be preserved if you only Group By Col1
Grouping...
September 20, 2012 at 7:28 am
preetid2 (9/19/2012)
Thanks Phil! this worked perfect!
I feel like I have entered a parallel universe.:alien:
September 19, 2012 at 1:45 pm
venus.pvr (9/19/2012)
September 19, 2012 at 12:30 pm
Eugene Elutin (9/19/2012)
SELECT Col1, Count_Rec
FROM (SELECT Col1, Col2, Count(*) AS Count_Rec
...
September 19, 2012 at 10:30 am
One thing which I have noticed with MERGE is that it does not natively provide separate Updated/Inserted/Deleted counts.
You need to code an OUTPUT clause and use $Action to get these....
September 19, 2012 at 10:27 am
preetid2 (9/19/2012)
Is this possible in sql server 2008?I want to use the column in the select, and group by. But want to hide the column from the results set?
No. If...
September 19, 2012 at 10:18 am
tutblog1 (9/19/2012)
Ok Brother,If anyone need to learn SQL just tell about this blog. Its help me alot.
Thanks,
Easily learn SQL with the help of images.
Is that because words are too...
September 19, 2012 at 10:15 am
keka4747 (9/19/2012)
Im new to SSIS . Need your help to resolve a performance issue.
I have a dimension table with 120 columns in which 80 columns change frequently and...
September 19, 2012 at 6:15 am
I second all of Sean's comments.
In addition, I note that you are referencing a column in your example which does not even exist in the table (ri_user_name).
I suggest that you...
September 17, 2012 at 1:22 pm
OK, I see that one.
I think your problem may be that your flow can go down either one path or the other, but not both.
The Execute ... task is waiting...
September 14, 2012 at 10:01 am
I'm sorry, that link does not work for me ("Sorry, that page was not found." is the message I receive)
September 14, 2012 at 9:31 am
Cool. I'm a bit short of time so can't go into detail.
But what you need to use is a package variable. Set its value in the script depending on the...
September 14, 2012 at 6:52 am
I'm afraid you might be in the wrong place. This is a SQL Server forum, not Oracle.
September 14, 2012 at 6:45 am
Viewing 15 posts - 10,426 through 10,440 (of 13,874 total)