Topics
Started by
Posts
Last post
Is there a way to run a T-SQL INSERT command and turn off triggers for the insert? I know I can di…
3 replies
hi all. we want to log changing data such as isert,delete and update that users perform.we can do t…
2 replies
Hello. We're in the process of migrating to a new data center, and we've got some of our sql server…
5 replies
how do I create a date table that autogrows everyday with a new row(date) being inserted everyday.
1 replies
Can some one help me in understanding the execution plan of a storedproc i have created a sp and ha…
2 replies
Hi, I need a function that will multiply by 2 any odd numbers and any even numbers to multiply by 1…
1 replies
It's been ages since I needed to perform one of these but I think I need to now. 1) I need to pull …
1 replies
Hi I am stuggling to combine this 5 queries in to one query.plz help me with this select c.claimid…
8 replies
Dear All , How to add 2 Temp-table Temp Table 1 : select no,name,age insert into #temp1 from empta…
4 replies
I have an existing query in place that I use to sum totals for various codes we do business under. …
4 replies
Hi folks I'm either having a touch of the friday afternoon stupids, or I'm a lot rustier than I tho…
5 replies
Example: Select COUNT(col1) OVER(Partition By col1) as 'First' , COUNT(col1) OVER(Partition B…
8 replies
I have a procedure which is-> ============================================================ creat…
11 replies
Hi all, I need small query which determines DateTime and count of records of a table. Examp…
2 replies
Hi, I've been doing some work on trying to optimize a procedure (Procedure A), so I wrote a new pro…
3 replies
Viewing 15 topics - 9,226 through 9,240 (of 10,647 total)
You must be logged in to create new topics.