Topics
Started by
Posts
Last post
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 a…
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
ALter PROCEDURE [dbo].[test] @frDate date, @toDate date, @VCode nvarchar(15) = null, @VName nvarcha…
10 replies
Hi Create PROCEDURE [dbo].[Test] @frDate date, @toDate date, @VCode nvarchar(15) = null, @VName nva…
10 replies
Hello, I am looking to create a cumulative report that forecasts potential future sales based on cu…
3 replies
Hi How the below statement works - AND Table1.ID2 = ISNULL(@Parameter3, Table1.ID2) Thanks
9 replies
Hi Is this correct way to enclose Dates & columns etc SET @Where = @Where + ' NOT(T1.U_APDE = '…
5 replies
Hi How the where condition works in below code. How IsNull & NullIf works. SELECT * FROM tblNam…
2 replies
Viewing 15 topics - 121 through 135 (of 3,062 total)
You must be logged in to create new topics.