Topics
Started by
Posts
Last post
Hey all, I have a stored procedure that calls many other stored procs - some of which in turn call …
3 replies
Hi, can anyone help with a code please. i need to create a trigger on a table 1 inserts (after inse…
4 replies
Hi, I had tried to create the following statements to capture the autogrowth of all the databases o…
4 replies
Good Morning/Evening! Just having one of those problems that I know is a doddle to fix but I cannot…
13 replies
Hi all, I have to write storeprocedure program should create a file.if not just show these results…
3 replies
Dear all; pls any one help Create proc get_result(@id int) as create table #tmp(cidint) inse…
3 replies
Hi, I'm new to execution plan.. select PO.PurchaseOrderID,PO.VendorID,PO.OrderDate,PO.ShipDate ,V.…
2 replies
Hi all, I'm wondering if there's a way to reuse a "just declared" alias, rather than having to expr…
2 replies
Hi all, n00by tsql guy looking for support here. Im trying to build a report on table that contai…
3 replies
hi, what will be best to use in stored procedure temporary table or table variable? thanks
3 replies
I am at a complete loss why this won't convert, BOL says this should be an implicit conversion. --…
7 replies
select Name,Block_Name,BlockType, HOURS , Month,cast((DP.Hours*PH.pp)as decimal(4,0))as tt1,PH.PP, …
7 replies
select @col = COALESCE(@col + ',','')+ QUOTENAME(Datename(month,work_date )) from form_Details WHE…
2 replies
hi all I need to Populate the city_summary table based on the customer and state table. customer cu…
2 replies
Hi fellow SQL Server gurus, *Edit 1: Corrected update statement WHERE clause to match the SELECT. …
13 replies
Viewing 15 topics - 6,541 through 6,555 (of 10,635 total)
You must be logged in to create new topics.