Viewing 15 posts - 421 through 435 (of 692 total)
It would only have to be a GLOBAL temp table if you are using bulk insert, or otherwise accessing it from separate connections. If the insert and all the manipulation is...
August 26, 2004 at 9:22 am
Dealing with a text file, I think a temporary table may be your best bet.
Steve
August 25, 2004 at 4:27 pm
I can't get my brain around it right now, but you may be able to do something with min or max and derived tables and maybe isnull, assuming you have...
August 25, 2004 at 4:24 pm
I'm assuming that the date_received column is datetime format. ...like '2004-08-20%' is character string manipulation and wouldn't work for datetime format.
What you need is something like...
select * from table
where...
August 25, 2004 at 2:24 pm
Here's a very simple script to do what you are asking. I also have a quite elaborate stored procedure that allows you to reindex the worst (number) of indexes or...
August 25, 2004 at 1:59 pm
Take a look at "Inside Microsoft SQL Server 2000" by Kalen Delaney. Chapter 6, specifically pages 252 - 254 will give you the structure.
Steve
August 24, 2004 at 4:13 pm
No, if you need that kind of information, you would need to set up an audit table and populate it with a trigger.
Steve
August 23, 2004 at 4:48 pm
Jill,
You're in very capable hands with Antares686, so to be honest, I haven't looked at your code. But I had to chime in with my 2 cents regarding cursors. So,...
August 23, 2004 at 4:44 pm
If you can, rather than modifying the system tables, try changing the owner of the dbs in question to some other user, your own Login for example, with sp_changedbowner. Then...
August 23, 2004 at 4:21 pm
If you don't have access to another instance, you may have to re-install. If you have enough space, you could install a named instance, backup Northwind ( or stop SQL...
August 23, 2004 at 10:38 am
Thank you for the update and for the explicit thank you!
Steve
August 23, 2004 at 10:16 am
The odbc connection wizard will only show dbs that the user has access to. You need to give the user access to the dbs you wish for him/her to use...
August 23, 2004 at 10:12 am
Row 17 from your view definition most likely wasn't row 17 from your query. SQL doesn't guarantee the order that your data is presented in unless you use an "order...
August 17, 2004 at 4:28 pm
I can't provide any advice, but I did have the same problem recently on a new server. Different hardware, but same OS. After a hard reboot, installation went fine, although...
August 13, 2004 at 3:46 pm
If all you want is the count, you could simply subtract the count(*) of the 3 views from the count(*) of the base table.
Steve
August 13, 2004 at 1:05 pm
Viewing 15 posts - 421 through 435 (of 692 total)