Viewing 15 posts - 5,941 through 5,955 (of 7,168 total)
Jeff Moden (6/21/2011)
Craig Farrell (6/20/2011)
June 21, 2011 at 3:50 pm
Heh, yeah, tell 'em I sent ya 😉
Out of curiosity brought about by something you said about "bulk", what's the client language? There may be a better way than any...
June 21, 2011 at 2:58 pm
Stringzz (6/21/2011)
You can use the TOP clause on the outer select, not the inner select.
Now,...
June 21, 2011 at 2:54 pm
b.lam (6/21/2011)
Lynn Pettis (6/20/2011)
June 21, 2011 at 1:30 pm
seth 98372 (6/21/2011)
...And new-and-improved the batch insert:
INSERT INTO sdj_test_table (ID, NAME)
SELECT -1006,' Bad Debt [CARRIER]'
UNION ALL
SELECT -1002,' Blue Cross [CARRIER]'
UNION ALL
SELECT -1003,' Commercial [CARRIER]'
Will a...
June 21, 2011 at 1:07 pm
Just know that this is not set-based, and is a horribly inefficient way to solve this problem, but you asked for it 🙂
There may be a less horribly inefficient, also...
June 21, 2011 at 12:51 pm
If you;re a trial and error guy then show me your trials 🙂 and then we'll work on the errors.
June 21, 2011 at 12:17 pm
Please have a look at this link:
http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D
You can use the function dbo.DelimitedSplit8K to split your comma-separated lists into rows and then join the resulting table to your #master table on...
June 21, 2011 at 11:39 am
Yes it can be done using a Cross Tab Query or the PIVOT operator. What have you tried so far?
June 21, 2011 at 11:23 am
Yes please. DDL stands for Data Definition Language. The term refers to any SQL code that constructs schema, e.g. CREATE TABLE, CREATE INDEX and ALTER TABLE...ADD CONSTRAINT, things like that.
June 21, 2011 at 11:15 am
I just set up the linked server on my side and found that the LDAP query did not work when providing TOP.
This worked for me:
SELECT *
FROM ...
June 21, 2011 at 11:07 am
Please post the DDL for the table in question, including all constraint and index definitions.
June 21, 2011 at 10:02 am
It can be done without a WHILE loop and can be done in a set-based manner. How large is the dataset we're talking about plowing through? I ask because there...
June 21, 2011 at 9:50 am
Cool article. I'll be interested to see how the new ORDER BY...OFFSET in Denali stacks up against Paul's technique.
http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx
June 21, 2011 at 9:37 am
You're welcome. If you happen to resolve it and have a moment to post the solution for others that would be great.
June 21, 2011 at 9:30 am
Viewing 15 posts - 5,941 through 5,955 (of 7,168 total)