Viewing 15 posts - 976 through 990 (of 8,731 total)
Papil - Tuesday, September 19, 2017 9:32 AMThanks got it to work.
It's considered good practice and polite to share your solution...
September 19, 2017 at 9:54 am
That's easy using MIN, MAX and DATEDIFF. What have you tried?
September 19, 2017 at 9:03 am
I have to admit that I've never seen the VALUES clause used...
September 18, 2017 at 2:50 pm
September 18, 2017 at 2:44 pm
Why would everyone read the table twice instead of just unpivoting it?
WITH myBeers AS(
/* snippet */
)
SELECT Person, SUM(OwedBeer) NetBeerOwed
FROM myBeers...
September 18, 2017 at 10:05 am
September 14, 2017 at 6:39 pm
Using Lowell's sample data, here are 2 other options.
SELECT [create_date],
LEFT( CONVERT( varchar(24), [create_date], 121),
CASE WHEN [create_date] = DATEADD(dd, DATEDIFF(dd, 0,...
September 14, 2017 at 2:22 pm
September 14, 2017 at 2:14 pm
For this, I might keep a more straightforward approach.
SELECT LEFT( YourFieldName, CHARINDEX('[', YourFieldName + '[')-1),
SUBSTRING( YourFieldName, CHARINDEX('[', YourFieldName + '[')+1, CHARINDEX(',', YourFieldName +...
September 14, 2017 at 12:08 pm
Read the following articles about dynamically pivoting tables:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - SQLServerCentral
Cross Tabs and Pivots, Part...
September 14, 2017 at 11:28 am
I have string with streetname ,city and state in the following folrmat.
I need to split...
September 14, 2017 at 11:13 am
September 14, 2017 at 8:44 am
September 14, 2017 at 8:02 am
TheSQLGuru - Wednesday, August 30, 2017 6:00 PMI sure hope someone can do some benchmarking on these!! :Whistling:
Here's a quick test. It...
September 13, 2017 at 9:00 am
UPDATE #Test
SET Dsc = REPLACE(dsc,SUBSTRING(dsc,1,1),'27')
WHERE ...
September 13, 2017 at 7:56 am
Viewing 15 posts - 976 through 990 (of 8,731 total)