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.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy