Topics
Started by
Posts
Last post
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
Hi How to convert below code like - CREATE PROCEDURE [dbo].[GetData] ( @Parameter1 varchar(256), @P…
1 replies
Hi I have given only date parameters . All other null , but it is not going in If condition -- ====…
1 replies
Hi Is it possible to do like this @ItemGroup is a parameter Select Itemcode,Itemname,ItemGroup from…
4 replies
Hi I have below parameters . @frDate date, @toDate date, @VName nvarchar(100) = null, @CName nvarch…
2 replies
Hi (Select Case (select count(*) from tbl1 T where T.num = T0.num ) when 0 then HCode=STUFF …
4 replies
Hi In below line i want if when > 0 instead of 0 then what should i change (Select Case (select …
1 replies
Hi How to use stuff function with 2 select statement . I want union all like condition . Result to …
6 replies
Hi I have below data and i want if both Sale & Purchase = 'N' then that record should not be di…
1 replies
Hi How to get Month Name from Date field Thanks
1 replies
Viewing 15 topics - 136 through 150 (of 3,067 total)
You must be logged in to create new topics.