Viewing 15 posts - 3,616 through 3,630 (of 7,187 total)
You're making things too complicated. Your result set contains only one row, so change the result set to No Result Set and use output parameters in the Parameter Mapping...
March 6, 2014 at 2:09 am
Koen Verbeeck (3/5/2014)
Setting the commit size to a lower value will commit batches before the entire load is done. What...
March 5, 2014 at 5:29 am
When you assign a result set to a variable, you're using a special type of variable (I think the type is called Object) that can hold a result set. ...
March 3, 2014 at 4:00 am
I'd say do away with the dynamic SQL and use a table valued parameter.
John
February 27, 2014 at 9:53 am
Use ROW_NUMBER, and join on a.RowNo = b.RowNo+1. Use COALESCE or ISNULL to deal with the NULL in the final row.
John
February 27, 2014 at 7:08 am
Will CURRENT_TIMESTAMP work for you? If not, how do you determine what "Day-1" is?
John
February 27, 2014 at 4:56 am
Abhas
You're going to need another job that polls the file folder at regular intervals. You can use xp_fileexist (undocumented, not sure that that's the correct name) or write your...
February 21, 2014 at 5:08 am
Vijay
The trouble with the SCD is that it processes one row at a time. If you are bringing in a lot of data, you might consider loading all the...
February 21, 2014 at 2:18 am
Why are you using dynamic SQL - why not something like this? I haven't checked the exact syntax, but you get the idea.
UPDATE Parts SET [TimeToTest]=
Convert(varchar, (select test...
February 14, 2014 at 10:05 am
I suspect that your error message tells you all you need to know, doesn't it? Just in case it doesn't, what does this return?
SELECT SUM(AMOUNT) FROM XACCD GROUP BY...
February 13, 2014 at 6:01 am
Use GROUP BY. If you show us what you've tried so far, we can show you where you're going wrong.
John
February 13, 2014 at 5:48 am
Good.
Exactly the same principle, except that the linked server process won't work. You'll have to search to find out whether it's possible to link to the local users and groups...
February 7, 2014 at 4:48 am
So local Windows account instead of domain accounts? Exactly the same principle, except that the linked server process won't work. You'll have to search to find out whether...
February 7, 2014 at 4:37 am
Suresh B. (1/31/2014)
Subrata Bauri (1/31/2014)
January 31, 2014 at 5:14 am
That information isn't stored in SQL Server. You'd need to set up a linked server pointing at your AD server, if your network admin will allow it.
John
January 31, 2014 at 4:53 am
Viewing 15 posts - 3,616 through 3,630 (of 7,187 total)