Topics
Started by
Posts
Last post
I have a trigger which declares a global cursor, a sp opens this global cursor and does some d…
4 replies
I have a website traffic logging system that was developed for a 2k system with the following spec.…
8 replies
I need to copy some databases into a reporting database. I'm using a metatable to house the informa…
1 replies
I have a locking mechanism in place for a web application, but when i run the sql below to get a li…
5 replies
why does this statement work select cast('2007/06/20' as datetime) and yet this one generates an …
2 replies
Hello, I am routinely performing SELECT INTO/INSERT INTO statements that perform scoring on 100-200…
1 replies
Can someone point out what's wrong with the following query. I want to see a list of tables that ha…
1 replies
Hi Please help me out declare @CID numeric(3,0) set @CID = 121 SELECT * from Table_name w…
1 replies
Hello I have this following TSQL command and i need to update field INTID with row number for each …
5 replies
Is there a performance problem if I use an OR in my query, example: (a bit simplified, but actually…
1 replies
Hello I was wondering if there is a syntax equivalent to field IN(value1,value2,value3) which mea…
9 replies
Hi, I am having some problems creating a stored procedure that performs a select and joins two tabl…
3 replies
The following script is NOT allowing me to SELECT * FROM #temp_Users -- (last statement below…
6 replies
I need to insert a record into another dabase but can you use a Case statment in the value clause? …
1 replies
Hello, I have a table containing large data, and one of the fields is a date field. Every minute th…
3 replies
Viewing 15 topics - 11,821 through 11,835 (of 12,234 total)
You must be logged in to create new topics.