Topics
Started by
Posts
Last post
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
A table hint would be used in a T-SQL query. So table hints would then be a sub-type of query hint…
4 replies
Hi All, select convert(varchar, getdate(), 103) 17/02/2012 select convert(varchar, '2012-02-17 15:…
7 replies
Hi, How can we store the Output value(s) from insert command into a variable.. instead of storing i…
2 replies
i have a query which is giving me dynamic data using pivot In that am using total as both columns a…
1 replies
I inherited a project originally developed within Access. One key component of this project is a hu…
1 replies
Viewing 15 topics - 6,556 through 6,570 (of 10,647 total)
You must be logged in to create new topics.