Topics
Started by
Posts
Last post
Hello, I have two tables in a 1-M relationship, Items and Versions. I'm trying to join the two such…
9 replies
I have a piece of script (reconciliation) that uses 2 x CTE to create a CURSOR. Now I am sure I ha…
4 replies
I want a stored procedure for booking a conference hall. we are taking the from date and to date fr…
5 replies
I am trying to connect to multiple servers using openrowset. but i am not able to pass a variable a…
2 replies
Hi, i need help on this i have a table called tableA WHICH HAS VALUES AS FOLLOWS COLUMN A …
6 replies
create Table #temp1 ( id int, Rno int, sno int ) insert into #temp1 values(10,125,32) insert into…
8 replies
I need to also get a 0 count when ther is no resources for the selected date. How would I do that? …
11 replies
In the code below. I want to get 1 record in Credentials CTE but it keeps getting 5, 1 for each rec…
4 replies
Hi everyone i'm woking with sql srvr 2005 express and the following sp is not working, here it goes…
7 replies
Hello, I'm using Row_Number() to page SQL results and running into an inconsistency in the results …
9 replies
I have a table with more than 200000 records and gets increasing. I am displaying these records in …
4 replies
Hi, I have 2 table with one-to-many relationship Table1 ID Value1 Value2 .... 1 a b …
4 replies
Hi Frends I have been asked to calculate the Rolling avg for a set of data Here is my sample data …
1 replies
Hello, I'm trying to write a report to show end of day bank balances over a period, but the table o…
11 replies
Hello folks, My company has recently migrated some of our apps from SS2K to SS2K5, and we have noti…
12 replies
Viewing 15 topics - 8,026 through 8,040 (of 12,230 total)
You must be logged in to create new topics.