Topics
Started by
Posts
Last post
Anyone has experience querying the data from "vertical table" having name value pairs? This is a sa…
5 replies
I write a lot of capacity planning scripts that either gather information about SQL objects (i.e., …
5 replies
I have two integers that I need a percentage number from such as 50/5000 = 5.00% I Know I ought to…
4 replies
How should I trap errors from nested stored procedures?? Example: create procedure usp_T2 as declar…
8 replies
Hi, I am having trouble in convert the data from one data type to another. I have a column which …
2 replies
how to use multi update i link server in one connection !!!! how --------------- UPDATE [pitable].[…
2 replies
Hi, I am having trouble in convert the data from one data type to another. I have a column which …
2 replies
Hello, I have a situation in which I need to evaluate a table field called 'td' (in a CASE stmt I'm…
5 replies
Hi, I'm using the following system: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) &nb…
3 replies
Hi, I have a temporary table into which I insert bulk data from a stored procedure output. It will …
8 replies
Can anyone tell me why example #1 fails, but example 2 and 3 will run? --Example 1: DOES NOT …
9 replies
Hi All, I'm a bit stuck as to the best way to handle the following.... Room_id Room_name 1 StaffRoo…
1 replies
Hello, my table contains 2 columns . EmpID varchar(10),ReportingToID varchar(10) how to write a que…
1 replies
To all, I found this script on the internet, however I keep getting an error when running on some s…
3 replies
I'm developing a stored procedure that accepts a string as an input parameter. I want to use that p…
10 replies
Viewing 15 topics - 11,416 through 11,430 (of 17,082 total)
You must be logged in to create new topics.