Topics
Started by
Posts
Last post
I need recommendation on which books to buy for SQL Server 2008 developer Thanks
2 replies
Hi all. How do you check if a record doesn't exist? I want to return an empty string for column3 if…
1 replies
Hi, I've got the following raw data: C100071540 1 10120101122 040039 using the fol…
1 replies
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
Viewing 15 topics - 9,001 through 9,015 (of 10,635 total)
You must be logged in to create new topics.