|
|
-
Mitesh Modi Commented 1 Months ago through Ask
<pre>
DECLARE @VSTNNO VARCHAR(20)
DECLARE @Cnt INT
DECLARE @AWBNo INT
DECLARE @FStCode INT = 2
DECLARE @TStCode INT = 3
DECLARE @MaxSTNId INT
SELECT @MaxSTNId=MAX(STNID) FROM GVSTNDetails WHERE FromStoreCode=@FStCode ...
|
-
Mitesh Modi Commented 7 Months ago through Ask
string str1="";
string str2 ="";
When you assign null to the variable you're telling the compiler to back off because you know better than him so he should not complain about this.
This is probably due to the fact that assigning null is conside...
|
-
Mitesh Modi Commented 7 Months ago through Ask
use stored procedure to pass date.
from your client application convert your string date input to datetime object and pass that object as parameter of date type.
Not use string parameter to pass date.Instead use date or datetime type parameter...
|
-
Mitesh Modi Commented 8 Months ago through Ask
DECLARE @i int= 5
DECLARE @Query NVARCHAR(MAX)
SET @Query = N'
;WITH cte AS
(
...
)
SELECT * FROM cte
OPTION (MAXRECURSION ' + CAST(@i AS NVARCHAR) + ');'
EXEC sp_executesql @Quer...
|
-
Mitesh Modi Commented 8 Months ago through Ask
Hi,
Try this query
with cte as
(
select *,row_number() over(partition by address,latitude,longitude order by address,latitude,longitude) as rno from address
)
select * from cte where rno=1...
|
-
Mitesh Modi Commented 8 Months ago through Ask
Hi,
sample table is same as used by chintak
select UID,DateValue,Description,CategoryID, sum(Amount) as InAmt,sum(amt) as ExAmt from
(
select UID,DateValue,Description,CategoryID, Amount,0.00 as amt from @TblIncome
union all
...
|
-
Mitesh Modi Commented 8 Months ago through Ask
check this below link may help you.
[http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4691fe01-79ca-4c09-8569-8e61d4b398ff/][1]
[http://msdn.microsoft.com/en-us/library/ms137795(v=sql.105).aspx][2]
[http://social.msdn...
|
-
Mitesh Modi Commented 10 Months ago through Ask
first of all get all the file list from different directory in one temp table with two column name FilePath and filename
then sort all data by filename.
Now you only have to merge file with same name...
|
-
Mitesh Modi Commented 10 Months ago through Ask
try below query
with CteDental1201 as
(
select count(*) as productivity,project,process,datename(month,date) [month] from dental201
group by project,process,date
)
select project,process,productivity,ProcTarget.Proc...
|
-
Mitesh Modi Commented 10 Months ago through Ask
try this link
[http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405b604614/][1]
[1]: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dd1d3552-68b2-46f0-a560-2c405...
|