SELECT * FROM TABLE_NAME WHERE Date_Column >= DATEADD(MONTH, -3, GETDATE()) Mureinik’s suggested method will return the same results, but doing it this way your query can benefit from any indexes on Date_Column. or you can check against last 90 days. SELECT * FROM TABLE_NAME WHERE Date_Column >= DATEADD(DAY, -90, GETDATE())
If you only want to perform some specific operations by your second SP and do not require values back from the SP then simply do: Exec secondSPName @anyparams Else, if you need values returned by your second SP inside your first one, then create a temporary table variable with equal numbers of columns and with … Read more
DELETE DELETE is a DML Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. We can specify filters in where clause It deletes specified data if where condition exists. Delete activates a trigger because the operation are logged individually. Slower than truncate because, it keeps logs. … Read more
use xp_cmdshell and sqlcmd EXEC xp_cmdshell ‘sqlcmd -S ‘ + @DBServerName + ‘ -d ‘ + @DBName + ‘ -i ‘ + @FilePathName
Select SUM(CASE When CPayment=”Cash” Then CAmount Else 0 End ) as CashPaymentAmount, SUM(CASE When CPayment=”Check” Then CAmount Else 0 End ) as CheckPaymentAmount from TableOrderPayment Where ( CPayment=”Cash” Or CPayment=”Check” ) AND CDate<=SYSDATETIME() and CStatus=”Active”;
I recommend you go over Using tables as Queues. Properly implemented queues can handle thousands of concurrent users and service as high as 1/2 Million enqueue/dequeue operations per minute. Until SQL Server 2005 the solution was cumbersome and involved a mixing a SELECT and an UPDATE in a single transaction and give just the right … Read more
You need to cast the text as binary (or use a case-sensitive collation). With temp as ( select ‘Test’ as name UNION ALL select ‘TEST’ UNION ALL select ‘test’ UNION ALL select ‘tester’ UNION ALL select ‘tester’ ) Select Name, COUNT(name) From temp Group By Name, Cast(name As varbinary(100)) Using a collation: Select Name Collate … Read more
Mostly you should do nothing about it. It is possible to disable the warning by setting ansi_warnings off but this has other effects, e.g. on how division by zero is handled and can cause failures when your queries use features like indexed views, computed columns or XML methods. In some limited cases you can rewrite … Read more
As others mentioned, split your string by GO statements. But be careful, you may have the text “GO” in other parts of your script. You might also have whitespace before or after the GO statement, and you might have comments on the line after the GO statement also. Any of that would be valid in … Read more
In order to be independent of the language and locale settings, you should use the ISO 8601 YYYYMMDD format – this will work on any SQL Server system with any language and regional setting in effect: SELECT CAST( CAST(year AS VARCHAR(4)) + RIGHT(‘0’ + CAST(month AS VARCHAR(2)), 2) + RIGHT(‘0’ + CAST(day AS VARCHAR(2)), 2) … Read more