Topics
Started by
Posts
Last post
Hi Any ideas on how to improve performance? @strMBRNO VARCHAR(255) AS SET NOCOUNT ON SELECT DIST…
9 replies
Hi Error - Each GROUP BY expression must contain at least one column that is not an outer reference…
4 replies
I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfi…
2 replies
UPDATE MyTable SET Num = 999 UPDATE MyTable SET Num = 999 WHERE Num <> 999 --ignoring nulls i…
1 replies
I'm after a simple trigger to audit inserts and deletes on a single table. If the PK does not exist…
8 replies
hi, 1) in following query i have changed the second ancher member which was getting father to mothe…
1 replies
Hey everyone. I'm a bit new to XML and had an issue with some formatting. I'm nesting XML queries a…
9 replies
This is a bit weird and I am trying to get my head around the issue - hope somebody can point me in…
1 replies
Hi Guys, I am currently making hard work of a dense_rank function, I am trying to calculate a new c…
4 replies
I appreciate it is utterly trivial question, and yet... When you have a small amount of columns, th…
11 replies
Hi I am getting data from Cte I want if @ICode parameter is not null then select statement should e…
3 replies
Hi I have below query . In T1.Sample1,T1.Sample 'Y' & 'N' is stored . I want to display Count o…
7 replies
Hi Inner select count(*) is not returning any data. SELECTT1.U_VendCode,T1.U_CabNo,T1.U_VendName …
4 replies
Hi When i print below Dynamic Sql it shows below statement in Print ALTER PROCEDURE [dbo].[Temp] @f…
2 replies
Hi Error - Column '@IND_RLS1.U_VendCode' is invalid in the select list because it is not contained …
2 replies
Viewing 15 topics - 121 through 135 (of 3,067 total)
You must be logged in to create new topics.