Topics
Started by
Posts
Last post
HI I am on SQL 2000 Query anaylzer and on my SP I have a Cursor with a huge Dynamic SQL statement…
3 replies
We have an application that inserts small groups of records (one record at a time) into a tabl…
2 replies
i'm attempting to use datediff to determine elapsed days between 2 fields defined as "int" with the…
2 replies
I have a computed column [DSC] AS (case when ([item_category] = 'TANN' and ([date] >= '2004-06-2…
6 replies
Hi, I know I can use EM > mydatabase > tables > right click mytable > create script …
5 replies
Hi Folks, I really wonder to know how to correct the mistake below.How can I use CASE statement????…
3 replies
Hi, I have a proc that needs to return a recordset to a web page where the user has selected (via c…
2 replies
Hello all. Hope you can help me out or point me in the correct direction. Looking to create a scrip…
8 replies
I have a table of users and date when they logged on to a system. I am trying to count how many dis…
1 replies
I need some t-sql advice please! I'm trying to get a notification if a table is not updated. I know…
3 replies
i create a table and insert rows create table T ( dt varchar(10) ) insert T select null insert…
5 replies
I have a vendor table that contains dates in an nvarchar2 column in the format mm/dd/yyyy hh:mi:ss …
7 replies
I'm trying to find the limitations of WHERE...CASE (Can you use an 'IN' expression? Can you use 'OR…
12 replies
Hi all, I have been searching all the forums but unable to find a answer to this problem. I am tryi…
2 replies
Dear All, Following is the description of the problem. Ex: My table mtab holds the data i…
3 replies
Viewing 15 topics - 3,166 through 3,180 (of 17,082 total)
You must be logged in to create new topics.