Topics
Started by
Posts
Last post
Hello Experts out there, How are you doing? The scripts provided below are adding columns into one …
3 replies
Hi, I have a query like given…Is there any way to give the RoomName dynamically. I have several roo…
1 replies
Let's say I have a table, named MyTable: RecordID int NOT NULL IDENTITY(1,1), Field1 varchar(50) NO…
6 replies
What I have: id|data|date 1|A|'1/28/08' 1|B|'2/02/08' 1|C|'2/03/08' 1|C|'2/09/0…
10 replies
The following query returns 'Divide by zero' error when recurDays = 0; select * from apptview where…
6 replies
I need to select the top record from a query and store two values from it into variables. something…
6 replies
Hi there, I am trying to retreive Column information from the DB. I am interested in getting Column…
2 replies
My requirement is to subtract 7 days from the the date passed as parameter if it matches with my H…
4 replies
Hello together, I have a problem with compilation of SQL Code. In my code I has two batches with a …
23 replies
I'm going to be working on a database on a 2005 sql server but the db is running under compat level…
4 replies
Hello everybody, I have IP addresses in one field. I need to display each set of values into differ…
5 replies
Hi All, I have one Dot Net application. Previously we were using SQL Server 2000 but now we want …
3 replies
select'1111' as First, '2222' Second, '3333' Third, '4444' Fourth, '5555' Fifth, '6666' as Sixth…
1 replies
I have 1 col in a table, and need to add a second col in the same table, something like following:…
6 replies
hey Guys, How can i set flag 1 and 0 for alternate rows using sql query? your help is appreciated..…
3 replies
Viewing 15 topics - 8,116 through 8,130 (of 12,230 total)
You must be logged in to create new topics.