Topics
Started by
Posts
Last post
Hi folks, I'm trying to optimize a query written by a previous developer, against a huge table (not…
28 replies
I have a table with columns EventID and DateofEvent Following is the Table Creation and Insertion S…
7 replies
I'm not new to SQL coding, although I was not aware of the CTE function until this week. I was look…
11 replies
I am trying to build a stored procedure using date selection with the date selection being a relati…
2 replies
Hello, I have a CSV file that contains e-mail addresses of our existing customer in the database. I…
4 replies
hi friends, in my previouse post, i have asked how to split csv with mutple columsn and rows and r…
1 replies
Hello I get an error when I run the following script, it seems I cant run an exec statment within a…
2 replies
Hi all, How would I rewrite this query to yield all routings that end in '1' ? Thanks all! select …
7 replies
Hi, I need to bring the result ,what r t months falls between two dates. (i.e) Eg.1 Declare @Fr…
5 replies
Hi guys, I am getting hardtime to arrange my results. i think its better to ask someone. I have a s…
6 replies
In 2005 Query Analyzer when I run a single record delete from a table the results show (1 row(s) af…
3 replies
When i was reviewing the stored procs..I saw a weird syntax in where clause inside a cursor.. up…
2 replies
Our company has a monthly summary table that is populated via stored procedure. It has around 100…
15 replies
Hi, Can we change the formula of an exisiting computed column in a table using T-SQL? I know it can…
2 replies
Table Structure Location Year Qty1 Qty2 Qty3 Qty4 Qty5 Qty6 Qty7 Qty8 Qty9 Qty10 Qty11 Qty12 Atp…
8 replies
Viewing 15 topics - 2,896 through 2,910 (of 12,234 total)
You must be logged in to create new topics.