Topics
Started by
Posts
Last post
I'm running a query into a temp table and it runs successfully but it displays the warning message …
7 replies
Dear All, I have one senario. which one is performance wise good ? Way 1: Create Table #Calculation…
3 replies
I have a customer who wants to see a definition of all tables, and more precise they want a row for…
4 replies
Hi, I need to write Triggers ( Insert, Update and Delete) on a table and insert the values in anot…
9 replies
Here is my problem: I have a table with 100 millions rows, table's structure is: t_all_combination …
12 replies
Dear All, I want to split the SELECT Clause output. Here is the senario. Insert into Log SELECT get…
5 replies
Ok so thanks to some help in a thread down below I can pass a use statement with a cursor to step t…
16 replies
I have a table called ReservationRooms which contains these columns: RESNO, ROOMNO, CHECKINDATE and…
3 replies
I have several sp's to make changes to. They bring back a few pieces of data. Now we want to brin…
3 replies
Hi, I'm new in stored procedures and I would need some help. The problem is that I need to know the…
4 replies
All, I am facing a problem while using Tally table. SELECT SP,Year,Month,DATEADD(DAY,-1,DATEADD(MON…
1 replies
Hi, I have a column which stores comma separated values eg.: 5,2,3,4,23,5,45,33,6,7,5,3 I want to c…
7 replies
Can someone please help me convert this script to run is SQL?! Colum 'Extension' contains some 10 0…
2 replies
I'm running SQL Server 2000 (SP4) and trying to get the debugger running. The client computer and …
1 replies
Dear All, I have written a function on passing of formid it will written the value with comma conta…
1 replies
Viewing 15 topics - 2,956 through 2,970 (of 17,082 total)
You must be logged in to create new topics.