Topics
Started by
Posts
Last post
I have a stored procedure that creates a dynamic query, then executes it as follows: Begin Tran Exe…
8 replies
If I am looking at the first day of a month, if I use the DATEADD function, I can add or subtract m…
4 replies
This is driving me crazy. I've done this before and I can't figure out why I'm getting this error.…
1 replies
Suppose there is a table TT with values col (type float) 1212.26 2345.45 0 -2345.45 -1212.26 Now if…
7 replies
hi , if i use the following query select tradername, isnull(sum(btty.debit),0)- isnull(sum(btty.cre…
3 replies
Hi All, I problem of creating sql statement to query the data about product code containning dash b…
6 replies
Hi, Does anyone know how I can pull just the numeric value from a varchar field which contains both…
10 replies
The table is somewhat like this Create Table #tab1( [HistoryID] [int] IDENTITY(1,1), [IssueID] [int…
3 replies
Hi All, I have to partition some tables (not databases) in ms sql 2005. Is it possible to do so wit…
5 replies
I had a project thrown in my lap and don't have time to rewrite another developers code, but need t…
6 replies
Why does the execution plan show a table scan on my Leads_DST table ?? I have an index on the List_…
9 replies
Hi everyone: I am writing a stored procedure en SQL Server 2000, this procedure has one INSERT stat…
19 replies
Hi, is it possible to get SQL to email information that it has collected from a query as an attachm…
19 replies
I need help calculating percentages of values in one column grouped by another column. Here is som…
3 replies
Hi, I have the following proc that is facing a performance problem. ALTER …
2 replies
Viewing 15 topics - 2,161 through 2,175 (of 17,082 total)
You must be logged in to create new topics.