Viewing 15 posts - 76 through 90 (of 327 total)
Not to protect weak interviewers.
...
So, I post a list. A manager reads it, memorizes it in the hopes it will help deliver the interview. A person masquerading as a DBA...
October 2, 2012 at 12:05 pm
What you are doing with the column list is building a list of columns that will be retrieved when the EXEC runs the sql command you build, and EXEC does...
October 2, 2012 at 11:49 am
Grant Fritchey (10/2/2012)
patrickmcginnis59 (10/2/2012)
Grant Fritchey (9/21/2012)
Lowell (9/21/2012)
Grant wanted to avoid putting the answers on the forum, but...
October 2, 2012 at 11:28 am
Grant Fritchey (9/21/2012)
Lowell (9/21/2012)
Grant wanted to avoid putting the answers on the forum, but i'd kind of...
October 2, 2012 at 8:59 am
Just a guess but why wouldn't you put the [status] column into the rollup clause if you wanted to use both the rollup clase and the [status] column?
October 1, 2012 at 2:21 pm
This will be an interesting one!
I can understand why EAV is not popular, but what other setup will let folks enter new attributes without defining new table columns? I know...
October 1, 2012 at 11:10 am
I think it makes sense on Microsoft's part, theres an increasing use of open source in all areas of computing, and Microsoft probably just sees good business sense in participating...
September 27, 2012 at 12:20 pm
Or we could put an index on the totaldue column 😉
SELECT TAB1.SalesOrderId AS ID1,
TAB1.TotalDue AS DUE1,
...
September 24, 2012 at 2:15 pm
A wild guess just for fun! Cue all smarter folks to line up and show how inefficient this query is!
SELECT TAB1.SalesOrderId AS ID1,
...
September 24, 2012 at 11:54 am
Just a guess, within a batch file, it might be seeing the '%' and subsequently expecting a parameter number to replace with a parameter. From a superficial web search it...
September 20, 2012 at 9:59 am
L' Eomot Inversé (9/19/2012)
patrickmcginnis59 (9/19/2012)
September 19, 2012 at 2:04 pm
I've seen product tables like that. One advantage to them I see is that the organization using this can enter product attributes and values for those attributes without having to...
September 19, 2012 at 11:22 am
You could try posting in the reporting services forum, maybe with a note that you realise you already posted the question once, but people might complain anyways about duplicate postings....
September 18, 2012 at 6:10 am
The nice thing about SQL is you can test theories. I tried the foreign key constraint idea:
"Cross-database foreign key references are not supported. Foreign key 'BLAH.DBO.TEST_TABLE'."
So I'm guessing NO on...
September 13, 2012 at 10:03 am
Maybe you could look at your cable modem for the network with the 2000 server and see if it needs to forward ports. One hint would be if the 2000...
September 11, 2012 at 12:11 pm
Viewing 15 posts - 76 through 90 (of 327 total)