T-SQL (SS2K5)
-
Topics
-
Slow Recursive CTE
Hi All I am using a CTE query for recording a list of purchase order numbers separated by a comma f…
-
Weird Question About Querying with Dates
Okay so this is a very odd situation, one that I have not seen before. I'm trying to query a table …
-
Database Design question regarding Normalized Tables
Hey all, Got a theoretical question for you guys. Let's say I have a table that contains informatio…
-
calculating ratios
Hello, I am trying to calculate a ratio, i am pretty sure the problem is in the line * SUM([SUMTOTA…
-
Need urgent help in a tricky t-SQL
Hi, Trying this for a long time but no results
need some help from experts here.
I have the f… -
Odd performance caused by Where Clause
So I have this odd issue that I can't figure out how to solve. I have a poorly written view which …
-
Convoluted DeDuplicate Related Records
I'm not sure the right terms here, but I have a puzzle, that is easy to see, but I'm stuck on how t…
-
Output of Dynamic variable to next query
Hi All, I have a table named tbl which contains 250 rows I have a Varaible @CNT = SELECT count(*) f…
-
bcp Errors
I am trying to run the following statement, but get errors. Any help would be appreciated. DECLARE…
-
Need Help in Converting Rows to Columns
Hi All, Can anyone help me in below problem. I have below result set dtDatesDocIdPrefixCNT …
-
Wrong Index Being Used
I was wondering if anyone has seen this before and has any idea why it is happening. This is occuri…
-
Is This Cursor Empty ?
I'm looking at some code for the first time, and am puzzled (happens a lot). The cursor "Membership…
-
daily weekly monthly calculate sum
hi guys, i need urgent sql query,kindly help me i need sql output like given parameter @startdate a…
-
Select Distinct last records
i have a table with three fields id,bank_id,amount it has alot of data....how i can select last ent…
-
Interview Questions
Hi Input 1 2 3 4 5 6 7 8 9 10 11 12 Output i want 1 4 7 10 2 5 8 11 3 6 9 12
Viewing 15 topics - 751 through 765 (of 12,234 total)
You must be logged in to create new topics.