Viewing 15 posts - 16,201 through 16,215 (of 18,923 total)
Can't find anything... but then again I don't know where to look.
June 27, 2005 at 7:25 am
Or can't you just do a cross db select??
June 27, 2005 at 7:11 am
I never used POSTGRES, but in sql server you must have the "as" keyword in there :
FOR INSERT, UPDATE, DELETE
AS
Declare....
June 27, 2005 at 7:08 am
It can't be done the way you want, the number of rows return will change with each column. You'll have to do 1 query per column (if you need...
June 27, 2005 at 6:48 am
For a simple count of all distinct values you can do this :
Select count(Distinct name) as name, count(Distinct id) as id from dbo.ObjSQL
June 27, 2005 at 6:43 am
Maybe we should make a little life story on this one, and add it up against the super lookup tables articles
.
June 27, 2005 at 6:32 am
Here's script that does just that... and more :
http://www.sqlservercentral.com/scripts/contributions/1468.asp
June 26, 2005 at 5:50 am
This can get you started :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=193380
June 26, 2005 at 5:45 am
Billiards (9 ball) and snooker
.
It's actually the first tournament of the season, go figure!!!!
June 24, 2005 at 9:02 pm
make sure that the account the server is using has access to the network, also make sure he can access the said folders and that he can create files in...
June 24, 2005 at 8:54 pm
Already told him that... maybe he'll pick it up this time...
But I feel I must warn him that since you're changing the query... you'll be getting different results from now...
June 24, 2005 at 6:19 am
Yup but this can be interpreted is any women is better at multitasking that man.
But just now, while I'm typing this, I'm listening the news on tv, music on the...
June 24, 2005 at 6:14 am
Viewing 15 posts - 16,201 through 16,215 (of 18,923 total)