Topics
Started by
Posts
Last post
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
hi, I have a stored procedure which i have broken down to this: @userID uniqueIdentifier AS BEGIN …
2 replies
Hi, I want to run a job in SQL 2005 Developer edition, where I transfer data from one table in a db…
13 replies
Hi, I need to select some columns from a stored procedure. With sp_help 'int' I need to select only…
5 replies
Hi, I have a problem with two SQL statements that each work fine on their own, but when I try to un…
12 replies
Viewing 15 topics - 11,821 through 11,835 (of 12,230 total)
You must be logged in to create new topics.