Topics
Started by
Posts
Last post
I am using @@IDENTITY to determine the ID of the last inserted value in a table (Table1). I use th…
5 replies
Lets say I have a "date" column (PK one row per day) and a "item" column (1 of 10 different items …
7 replies
System: I have 50 jobs recurring every 10 seconds to concurrently update a 5000 row table called Cu…
44 replies
Hi Friends, I need some help with a query. I have a table Test that stores the marks of students. …
1 replies
Hi everybody, I have to do a search & replace into a bunch of text type fields - in order to u…
10 replies
Greetings once again. I am working on some sql to be used in a report. I have a transaction table …
5 replies
Hi , I have 2 columns where some rows have -ve numbers and some rows have +ve number...I need to su…
2 replies
IF OBJECT_ID('TempDB..#Question','U') IS NOT NULL DROP TABLE #Question IF OBJECT_ID('TempDB..#Answe…
2 replies
I have a sql statement that outputs numbers to 2 decimal places. When I execute the same sql statem…
2 replies
Hi, I'm trying to create an XML output file with some hierarchy using a a SELECT...FOR XML clause,…
1 replies
Hi. I didn't realize that if you add a row to the underlying table while a forward only cursor is r…
18 replies
The following statement will show you information about your instance and the file space used. how …
1 replies
Okasy I have been racking my brain to understand why this will not use the 'use' cammond in the fir…
5 replies
Interesting problem here. There is an application that insert/updates/deletes from a table but is v…
5 replies
Hi Guys I have got a range of numbers which are actually the number of tests done by the doctors ov…
8 replies
Viewing 15 topics - 6,301 through 6,315 (of 12,234 total)
You must be logged in to create new topics.