Viewing 15 posts - 5,371 through 5,385 (of 14,953 total)
siamak.s16 (1/10/2011)
January 11, 2011 at 10:47 am
Jeff Moden (1/10/2011)
BaldingLoopMan (1/10/2011)
also it is bad proctice to default ur input params to null. If its a varchar it's not so bad however dates. Not so good.
I have to...
January 11, 2011 at 10:41 am
Jeff Moden (1/10/2011)
WayneS (1/10/2011)
Craig Farrell (1/10/2011)
GSquared (1/10/2011)
Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.
I...
January 11, 2011 at 10:39 am
GWAk (1/10/2011)
If your ability to communicate via the written word is not the problem, but rather, the ability to communicate effectively, face-to-face,...
January 10, 2011 at 12:38 pm
It looks like what you're trying to do is a "catch-all" proc, of the sort usually built for complex search pages. If so, take a look at the entry...
January 10, 2011 at 12:26 pm
It's a standard many-to-many join.
Join the vendor table to the info table, then join the info table to the project table.
January 10, 2011 at 12:21 pm
Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.
January 10, 2011 at 11:10 am
Weird. I've never had trouble with that one.
Microsoft doesn't seem to have any data on it at a quick search of MSDN (I'm assuming you looked in more detail,...
January 10, 2011 at 11:07 am
Personally, I think I'd set up a query using OpenRowset to pull data from the CSV files, and Merge to upsert the data. That'll be the easiest way to...
January 10, 2011 at 11:00 am
bitbucket-25253 (1/8/2011)
http://whathappenedinmybirthyear.com/
Go ahead, go to it, input your year of birth, now it is not video, but...
January 10, 2011 at 8:43 am
GilaMonster (1/10/2011)
Am looking for proof-reader for article on reasons for transaction log space not being reused. Any takers?
Sure.
January 10, 2011 at 8:33 am
GilaMonster (1/9/2011)
Craig Farrell (1/9/2011)
If the USA isn't the center of the world, why does it seem like a lot of people keep gravitating to it?
Very bad joke (with bad physics)...
January 10, 2011 at 8:31 am
Confio Ignite can help a LOT with performance tuning. Helps you narrow in on exact statements that are causing problems.
January 10, 2011 at 7:26 am
No. Like this:
''value1'',''value2'',''value3''
Note that those are NOT quotation marks, they are double-apostrophes.
January 10, 2011 at 7:25 am
Viewing 15 posts - 5,371 through 5,385 (of 14,953 total)