Topics
Started by
Posts
Last post
Good Morning All, This topic is not exactly a SQL question, but it is remotely related. Via SQL DB…
4 replies
Below is a simplified version of a select statement that returns the error ("Msg 4104, Level 16, St…
8 replies
Hi, declare @today varchar(3),@backupString varchar(255) select @today= CASE DatePart(dw,getD…
2 replies
Dear All, how are you i am using SQL server 2005 Enterprise Edition, and require a help below is m…
19 replies
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
Viewing 15 topics - 8,026 through 8,040 (of 12,234 total)
You must be logged in to create new topics.