Topics
Started by
Posts
Last post
Hi Guys, I need your help. I have a store procedure and its taking to long to execute that package…
6 replies
Hi all, I need to write a query that, for a given DB, will show: - all the tables - every column fo…
10 replies
I have this table of budget values. I need to pivot the budget values to make a fact table. Then I …
2 replies
We have a table strucure as below.. Tabe-A A-d-int,pk,notnull A_H--nvarchar(10),null A_dn-navrchar …
9 replies
So I am trying to record how long my SProc takes to run. More precisely, how long each step of my p…
4 replies
Today I had a question : Not exists or Not In which one is better for perfomance??? Or any other y…
4 replies
Hi SQL Masters, For MS SQL starndard process, anyone can provide how to resolve this one? Details: …
2 replies
Greetings all. I have used CTEs so I am familiar with their usage however, I need to create a recu…
35 replies
I have a table with a column having data as below: I am looking to split the data of this column to…
1 replies
I a typical Customer order scenario, there is a header record and one or more lines records per hea…
17 replies
So ... I have some views that consist entirely of tables across a linked server. My challenge is to…
2 replies
Hi I need to put in my WHERE clause some script that identifies data that is within the last year.…
8 replies
Dear All, I need your help on generating the list of week numbers between two dates with Monday as …
8 replies
Requirement Table SO_ID REQ_ID SKILLCODE0001 00011 0001693-5-4, 0001798-2-3 0002 00011 0001234-3-2,…
1 replies
I need to use a value returned from a function in a where clause. I get the code to compile ok but …
13 replies
Viewing 15 topics - 5,596 through 5,610 (of 10,644 total)
You must be logged in to create new topics.