Topics
Started by
Posts
Last post
I declare SUM variable , then i want to put value into it from below cursor , when i wrote : (SELEC…
19 replies
Hi, i have three tables Main Category, Sub Category and Product Category with the sample data as be…
2 replies
I have a table with the following data in 1 column part 1 region 10 area 7 part 2 region 11 area 8 …
8 replies
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
Viewing 15 topics - 5,596 through 5,610 (of 10,647 total)
You must be logged in to create new topics.