Topics
Started by
Posts
Last post
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
I was surprised to learn from one of my colleagues that using value1 = value3 ran faster than value…
6 replies
Hi, I have a store proc that execs 2 others before it builds the temporary table that I want to use…
14 replies
Viewing 15 topics - 6,301 through 6,315 (of 12,232 total)
You must be logged in to create new topics.