Topics
Started by
Posts
Last post
Hi experts, In the below case statement, the Salespersonflag column is being returned. when i use t…
3 replies
Hi, I am trying to change a variable based on the results of the same variable. Is this possible or…
2 replies
I'd like to create a stored procedure with parameters which returns a query result. Pretty simple …
57 replies
Let's say that I have a table as shown below: Create table dtl (id Int, fk Int, dtl_note char(30)) …
4 replies
I have two queries. they both return different data, despite looking very similiar. The only differ…
6 replies
Hi i have read that only one unique clustered index can be created on a table and many non cluster…
9 replies
I'm a little confused with some code which is updating records in a table. Wonder if anyone out the…
5 replies
Hi, I have the following UPDATE statement of a table joined with itself: UPDATE childTbl SET child…
4 replies
Hi I was hoping a TSQL guru can make a recommendation for optimizing this query SELECT top 50 CA1.…
10 replies
Suppose I am creating a login called 'TestLogin' and assigned Public & bulkadmin server level …
2 replies
SELECT 'IN' AS TRTYPE, I.INVOICENO AS TRID, I.INVOICEDATE AS TRDATE, dbo.GetFinanci…
3 replies
I import files into SQL 2000 DB that contain First Name Last Name. Recently a a file came in that …
3 replies
How do I use a lookup table (on SQL SERVER) without hardcoding the (business rules) values within S…
2 replies
((@VarEmp_Id=0) or (@VarEmp_Id is null)or (Employee.Emp_Id=@VarEmp_Id)) And (Emp_Nam…
2 replies
I hope you guys can help me, I’m stumped This is on SQL SERVER 2000. I want to process id’s in a …
8 replies
Viewing 15 topics - 9,016 through 9,030 (of 10,647 total)
You must be logged in to create new topics.