Topics
Started by
Posts
Last post
I working on a mobile/cell phone database. Unlike in the original db I will use english column name…
12 replies
Hi, I have a list of records in a main table that has two other tables associated with it so that …
9 replies
Hello, I have a linked server and I can do select queries fine: For example Select * from linkedser…
7 replies
Hi guys, How do i pass a table name as a parameter to a stored procedure? The following code giving…
2 replies
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
Viewing 15 topics - 11,461 through 11,475 (of 12,234 total)
You must be logged in to create new topics.