T-SQL (SS2K5)
-
Topics
-
Cursor and update
Before Script Runs Seller_No|Product_No|Product_Status 99999 |100000 |Availalble …
-
Stuck on Substring/Left/Charindex Problem with Description
This works for some items and not others. I can't explain it. What I need is value of 20, 15, or 10…
-
Strange behaviour of some jobs ...
I have no idea where to even start with this one. I have a schedule which has about 40 jobs running…
-
Nan,#Error,Infinity Values displaying in ssrs reports
When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I want…
-
Get Unique Transaction ID For The Current Transaction
Hi all
When multiple tables are updated in a single transaction, is there any way to tie those ch… -
List DB users
I was looking for a method of querying my SQL Server 2000/2005/2008 databases to gather a list of D…
-
Index with a column varchar(50)
Is recommended that créate an index with a column that is varchar?
-
Calculate Past Due Principal and Past Due Interest Based on Due Dates
Hi with respect to my subject, need to calculate -Calculate Due Amount Principle + Interest after D…
-
Trace Script for XP_CMDSHELL
Is there a way to use a trace and capture only when XP_CMDSHELL is used, and what used it?
-
How to write a Query to get related result
I need help to write a query like below oupt put. create table #table (id int, cid int , startdate …
-
Data containing '
Is there any way to delete data that contains ' ? example - desc field is "Bene's" Trying to delete…
-
Query advice on removing duplicate fields
hi all i have a query - which i may be best going back to the start on, but ill ask first if someon…
-
Query Question Using Distinct concept in table joins
Hi - I have 4 tables that I need to join and return distinct results. TableA is my main table and …
-
How to pivot but to keep one column unchanged
i have a table with 3 columns like below ID, Name and Value. It has like 1000 records ID Name Value…
-
CTE results storage same as temp table?
Simple question, are the results of a CTE stored in the same place as a temp table (tempdb)? Thanks
Viewing 15 topics - 436 through 450 (of 12,234 total)
You must be logged in to create new topics.