Viewing 15 posts - 5,461 through 5,475 (of 7,191 total)
This appears to be the special case where your interval is a multiple of 10. You can resolve this by changing your outer join into an inner join and...
April 4, 2011 at 4:44 am
OK, what you're looking for is a function to split a comma-separated list into its individual components. You should be able to find one by searching this site for...
April 4, 2011 at 2:02 am
I've got absolutely no idea what you mean. Please will you supply table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements,...
April 1, 2011 at 7:53 am
You seem to have mangled my original code a little by changing number to NUM and removing the [font="Courier New"]AND name IS NULL[/font] line! I assume you used your...
April 1, 2011 at 7:21 am
As I said in an earlier comment, and as Sam said, check the RetainSameConnection property of the task. If that doesn't work, use a global temp table (but don't...
March 31, 2011 at 9:27 am
This should get you started. You can use it to create a table valued function, which you can CROSS APPLY to your table to get the results you're looking...
March 31, 2011 at 9:23 am
True, but I was assuming both versions are 64-bit. Saurabh doesn't specify.
John
March 31, 2011 at 5:40 am
Saurabh
You might consider installing the development tools on a client PC instead of on the server. That way, you can keep your development separate from the function of the...
March 31, 2011 at 4:10 am
Then you'll need to use the Windows scheduler to invoke sqlcmd and run your stored procedure.
John
March 31, 2011 at 3:39 am
Besides, as far as I know, sysadmin logins have full access to the server, even overriding any DENYs that may be in place. This applies even if you drop...
March 31, 2011 at 3:04 am
It's good practice to remove the BUILTIN\Administrators login and just grant access to those who need it. Be very careful when you do this on a clustered instance, though...
March 31, 2011 at 2:39 am
Temp table is necessary, not table variable. A table variable only lives for as long as the batch that creates it.
John
March 31, 2011 at 1:48 am
CELKO (3/25/2011)
We have a CASE expression; it is no0t a CASE statement! IMPORTANT DIFFERENCE.
Nobody used the phrase "CASE statement", did they? It's a difference, granted, but an important one?...
March 28, 2011 at 1:41 am
Ken
I think there's a property of the package called Delay Validation. Try setting that to True. That way, SSIS will not try to check that the Excel files...
March 25, 2011 at 9:23 am
Viewing 15 posts - 5,461 through 5,475 (of 7,191 total)