Topics
Started by
Posts
Last post
Is using too many temporary tables (#Temp..) in an SP, a bad practice by any chance? Or does it ham…
27 replies
In many of our reports we query the Time table to get staff time data. Now each staff is assigned t…
2 replies
select getdate() as todaydate, cast(getdate() as varchar) "diff format" ,cast(getdate()+1 as int) a…
20 replies
I need a query that gets all of the databases on a server and determines if a backup has been taken…
2 replies
Hi I came across the following query in a 3rd party application that left joins the same table tsc…
4 replies
I need to join these three tables to generate monthly totals. The Attribute_Value table has values…
7 replies
Which pair(s) of the three clauses consist(s) of equivalent ones please: (1) FROM a LEFT JOIN b ON …
1 replies
hello, is this acceptable in a stored procedure? CREATE Procedure Search @TicketID int AS BEGIN S…
19 replies
By: MeThinks
Hi All, I need to be able to set a flag from 0 to 1 when the datetime field within the same table i…
4 replies
Hi, I store databases in the form of scripts(Generate Scripts), If i have Stored procedure which wa…
16 replies
I have a file that needs to be bulk inserted into a table. I have two issues. The file may or may…
25 replies
How can I easily pull out the uniqueID for the latest revision on each of the SNs in the table belo…
9 replies
Here is the problem that I need to solve.I want user a to be able to query 100 records and update a…
14 replies
It would not surprise me if someone wanted to reach through the internet and throttle me. Using th…
9 replies
HI, Have some Stored Procedures some part of data is static for all SP want to use is in smarter wa…
7 replies
By: GSquared
Viewing 15 topics - 10,606 through 10,620 (of 12,234 total)
You must be logged in to create new topics.