Topics
Started by
Posts
Last post
Hi i need a query for below scnario [font="Arial Black"]TblMaster[/font] ID NAME 100 James 101 Jose…
2 replies
Hi, I have the following table : Month, Year, TeamNum, Ext, AvgHoldTime,TotSCI, TeamAvgHoldTim…
1 replies
i have this query which runs good on sql server 2000: select col1,col2 from table1,table2 where tab…
19 replies
Hi, I have the following table : Month, Year, TeamNum, Ext, AvgHoldTime,TotSCI, TeamAvgHoldTim…
3 replies
When I run a stored procedure, it asks for the parameters. It remembers the previous supplied parm…
4 replies
I have a table named Courses which contains course information as well as a column named No_Units, …
6 replies
I tried to delete rows from a table with inner join with another table based on keys. But I am unab…
2 replies
I use this to get the date: DECLARE @date as VARCHAR (10) SET @date = convert(varchar,getdate(),103…
4 replies
Hi, Can we load an Excel file in my machine from client to the server using openrowset or opendatas…
1 replies
Hello, I have a query that claculates the average number of days to ship an order. SELECT CAST((b.…
8 replies
Hi guys, does anyone here knows how write a script that can switch between database context? for ex…
3 replies
Hi, Is it possible to create a simple CTE within a stored proc and reference the CTE multiple times…
8 replies
hi guys, can anyone tell me the best way to trim spaces after a name in my column productname in my…
24 replies
let's say I have this one, no problem: CREATE PROCEDURE au_info @var text AS DECLARE @hDoc int E…
3 replies
Hi All, I am having 2nos. of Table. 1 st table contains Id | Name ------------ 100 abc…
4 replies
Viewing 15 topics - 9,916 through 9,930 (of 12,230 total)
You must be logged in to create new topics.