Topics
Started by
Posts
Last post
Hi all, Can anyone please let me know a way I can generate a report as below. SalesPerson's Name …
3 replies
We want to import an XML file like the one below (which will contain many more s, I'm just showing…
1 replies
column 1 (char), column 2 (char) column 3 (int) column1 (vendor_num) has duplicate numbers column 2…
2 replies
Hi all I was wondering, in the light of SS2K5 now supporting the use of variable in SELECT TOP stat…
13 replies
I have an xml like following I want to write an sql query which returns only if the IsGroup value i…
5 replies
Hi All, 1st Qst : I am really Confused why I will use Hash Join, I mean to say in what circumstanc…
2 replies
Example Select Giver.name,Env.RecieptNum, Env.Date, (Select sum(Env.Amount) from env,l…
3 replies
I'm trying to use CTEs to get away from lookup type UDFs. I was told in another forum here that Gr…
2 replies
I am pulling the average uptime of router for my company. I built a query to give me something like…
3 replies
Getting an arithmetic overflow operation error. Looking for T-SQL to limit my output to 5 decimal …
2 replies
I have the following SP: CREATE PROCEDURE proc @param1 varchar(20), @param2 varchar(20), @param3…
9 replies
Hi, I m sarvesh, i have a problem in sql. i have a table and i want fetch distinct records on two f…
20 replies
The middle tier development group has a set of unit tests that they run against the database. The o…
7 replies
In our hierarchy, we have 12 classes which represent all possbile objects in the hierarchy. All P…
2 replies
Hello I have a table (contacts) with this format: clientType, clientID , contactusage, contacttype,…
3 replies
Viewing 15 topics - 11,461 through 11,475 (of 12,230 total)
You must be logged in to create new topics.