Topics
Started by
Posts
Last post
Hi, I'd like to know what the best way to return multiple values from a stored procedure. I've loo…
3 replies
I have a DBCC Statement, for which i get results into the table. Like this; Create table #getlogspa…
2 replies
Hi forum, I'm trying to use populate a table variable from different tables and then update certain…
5 replies
SQL is great at getting data, it’s terribly awful at formatting data. I was hoping someone might b…
2 replies
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
Viewing 15 topics - 8,116 through 8,130 (of 12,234 total)
You must be logged in to create new topics.