Topics
Started by
Posts
Last post
This is a two part question concerning the use of CASE in a SELECT statement. I am trying to write …
5 replies
I'm trying to retrieve the list of drives where each db is created by selecting in the sysfiles. Th…
2 replies
What is the best way of executing a stored procedure within an AFTER INSERT trigger for every recor…
2 replies
I am attempting to write a trigger that prevents changes to a table. My logic is as follows: 1) Ch…
2 replies
FROM SQL BOL : "IDENTITY (Function) Is used only in a SELECT statement with an INTO table clause to…
9 replies
I am trying to compute the percentage of times each minimum amount (minAmt) category occurs. When …
5 replies
So, I need a query that will return the same rows of data in a completely random order every time i…
22 replies
Guys, the code below returns a bunch of result sets and I need it to return one result set. Just in…
1 replies
What's the preferred method for error handling in stored procedures? Most of our user interfacing i…
5 replies
Here's another one for the Gurus out there. These two queries get two different numbers. I don't un…
2 replies
Hello, I have several tables with the same structure e.g. for each single process. I pass two param…
5 replies
This is a trigger to record Updates to a table that I modified from O’Reilly’s “Transact-SQL Cookbo…
2 replies
I have a table as below cp_Name varchar(120) MonthPeriod int(4) Headroom money(8) I want a…
8 replies
Greetings, I am getting an error 22029 when I try to run a Transaction Log Backup job when using xp…
4 replies
Hi all, This is a strange one. I have a stored proc that in the body has 3 checks against the vari…
9 replies
Viewing 15 topics - 15,871 through 15,885 (of 17,082 total)
You must be logged in to create new topics.