Viewing 15 posts - 16 through 30 (of 337 total)
Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be then easily...
March 31, 2016 at 9:03 am
Here is some interesting reply.See if it works for you.But I strongly believe read only across version is never supported.
you can use standby if you have initialized the database I...
March 31, 2016 at 2:14 am
Sorry did not realize that you had posted in 2008 section.Lead can be easily replaced with a left join.
DECLARE @STARTDATE DATE='2005-07-01'
DECLARE @DAYS INT=100
DECLARE @INTERVAL INT=7;
WITH cte
...
March 31, 2016 at 1:46 am
If you are still not aware how to use my earlier query here is the sample usage on AdventureWorks2012 DB that SUMS Totaldue for 100 days spilt into 7 day...
March 30, 2016 at 11:19 pm
This query will give you the start and end date over a 7 day interval for a period of 100 days depending upon the current date.
;WITH cte
...
March 30, 2016 at 10:57 pm
Thanks Phil and Steve for your replies.The solution worked for me.
March 30, 2016 at 8:49 pm
Looks like "Prevent" and "Log Only" are not supported for tables which is quite strange though it's supported for Stored Procedures and UDF's
SELECT
f.[name] [FacetName]
,ISNULL(p.d,'') [On change: prevent]
,ISNULL(l.d,'') [On change:...
March 30, 2016 at 8:33 pm
Sorry..There was a silly typo in the earlier query.
SELECT *
FROM (SELECT *,
Row_number()
...
March 30, 2016 at 7:27 pm
I probably think this query would perform better.
SELECT cust_name,
cust_state,
(SELECT Count(*)
FROM orders
...
March 30, 2016 at 12:40 am
Quick fix would be take a Full backup,Put the database in single_user mode(some downtime would be needed),change recovery to SIMPLE,truncate the log,change recovery to FULL,put db in MULTI_USER,take a DIFF...
March 29, 2016 at 11:09 pm
Something like this...
SELECT *
FROM (SELECT *,
Row_number()
...
March 29, 2016 at 10:29 pm
mithunbhora (3/29/2016)
... "Since we are defragmenting the same index, then why the extra space is being swallowed up by New index, although the previous one is being deleted automatically,...
March 29, 2016 at 10:09 pm
tolusokan (3/29/2016)
I have been battling with this query for a while now. I attached a snippet of the raw file (claim) and also a sample of the expected results....
March 29, 2016 at 9:31 pm
Something like this
SELECT *
FROM (SELECT *,
Row_number()
...
March 29, 2016 at 9:21 pm
Or..
SELECT T.prod_code,
sc.ship_code
FROM #shipping_codes sc
LEFT JOIN #mastershipping ms
...
March 29, 2016 at 9:18 pm
Viewing 15 posts - 16 through 30 (of 337 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy