Topics
Started by
Posts
Last post
Hi all, Got a bit of a strange problem that I need to solve. Lets say I have two tables, like so: …
29 replies
Hi, I am trying to 'tune' one of our applications housekeeping scripts, which runs against dozens o…
13 replies
My colleagued just showed me some sql code inherited from a previous developer that contains an "or…
9 replies
Hey all, I have this statement in a where CASE WHEN ISDATE(PAD.AdditionalDetail1) = 1 THEN CONVERT…
2 replies
I'm stumped, and I need help solving a mystery regarding assingnment of a variable to the output pa…
6 replies
Hi, I am running a SSRS program that selects data across 2 linked servers. The process has to be co…
2 replies
I have a table as follows in sql 2005 CustID - ProductName - IndexValue1 - IndexValue2 - IndexValue…
13 replies
I captured a query similar to the following in a profiler replay trace. When replaying, it failed …
5 replies
HI all, i want to write log of error occured in stored Procedure,how i can write down SP For that.H…
7 replies
Hi Need help with concatenation and pivoting: @table 1 is as follows ID More_id …
2 replies
I'm trying to write code for some Column Headings in an SSIS Package. The following works: SELECTC…
3 replies
Hi guys, I am getting error when trying to execute database profile and database account through st…
1 replies
Hi all, Not sure if this is the correct forum to be asking this, but I've got a question about the …
16 replies
How can I improve this query? Any help would be greatly appreciated. SELECT Comp.CompanyName, LEFT…
21 replies
All, I would like to know the performance difference between PRIMARY KEY WITH CLUSTERED and PRIMARY…
13 replies
Viewing 15 topics - 1,561 through 1,575 (of 12,234 total)
You must be logged in to create new topics.