Topics
Started by
Posts
Last post
Hello all, stuggling to figure out how to do a Distinct first instance, if thats the correct way to…
4 replies
Hi All, I have table with columns: [ASSOCIATEID] [LASTNM] [FIRSTNM] [STRNBR] [DPTNBR] [TYPE] [DateW…
1 replies
I asked helped about this query a couple of times but never got a finalizing answer.So please bear …
6 replies
I was waiting to get my MSDN license. So for time being I installed SQL Server 2005 Express for the…
6 replies
Hi there, I'm struggling a littel bit with the following query not doing what I think it should be …
3 replies
Ok, I know my Subject line isn't great, but I'm not sure exactly what I am looking for. I'll give a…
6 replies
So let me see the experts here .... 🙂 I have a table : "ROOM_PRICES" Room_type start_date end_date …
19 replies
Hi all experts... I am new to sql .. and need ur help in writing the SP for the below: I have two t…
1 replies
Need to find the length of stay. Using datediff to find the number of days between admission and di…
2 replies
hey , I am tring to removed duplicates without distinct keyword and temp table. please give me any …
14 replies
Hi All, I have a doubt that if i used more than one DML command on same object i mean if i update …
6 replies
Hi, If we consider the below: declare @m as table (a int, b int) declare @n as table (c int, d int)…
7 replies
Hi I am trying to get my head around the various options of handling errors in 2005. We are writing…
3 replies
Hi, I have an SP which runs at night to populate certain tables from production to Dev. The job ru…
4 replies
Hi all, This must be a silly question....Is there a way to add 008 + 1 and get the result as 009 in…
6 replies
Viewing 15 topics - 511 through 525 (of 2,735 total)
You must be logged in to create new topics.