Viewing 15 posts - 1,081 through 1,095 (of 8,731 total)
It's possible to do it with PIVOT, but you need 2 different variables for your columns. Instead, I recommend you to use cross tabs which can give better performance. You...
July 24, 2017 at 10:06 am
July 24, 2017 at 9:45 am
This code is wildly open to SQL injection. If you don't know what I'm talking about, please google it.
Scratch that.
This code has no reason to be dynamic. It...
July 24, 2017 at 6:46 am
If I understand your problem correctly, you just need to remove the quotes.
Orderby=( case @id when 1 then varieteit else stockeerder end )
July 24, 2017 at 6:16 am
A different option:
SELECT
I.ADDRESS_1
,CASE WHEN I.ADDRESS_1 LIKE 'PO BOX [0-9]%' AND STUFF(I.ADDRESS_1, 1, 7, '') NOT LIKE '%[^0-9]%' THEN 1
July 24, 2017 at 6:02 am
This would work, you just need to change the variable to use the column that you need.SUBSTRING( @[User::Code] , 1, FINDSTRING( @[User::Code]+"..", "." , 2) -...
July 24, 2017 at 5:53 am
July 21, 2017 at 2:24 pm
komal145 - Friday, July 21, 2017 12:21 PMThanks it works.
Do you understand why and how it works?
July 21, 2017 at 12:24 pm
robin.pryor - Friday, July 21, 2017 11:42 AMSELECT reverse(left(reverse('\\CORP-BI-DEV-01\Temp\TIVExplorer\vzwprices-2017-06-21.json'), charindex('\', reverse('\\CORP-BI-DEV-01\Temp\TIVExplorer\vzwprices-2017-06-21.json')) -1))
There's no need to use 2 reverse functions. This is important...
July 21, 2017 at 11:58 am
komal145 - Friday, July 21, 2017 11:36 AMfrom the given string need to extract the filename:\\CORP-BI-DEV-01\Temp\TIVExplorer\vzwprices-2017-06-21.json
How can i get tihis?
With extension or...
July 21, 2017 at 11:40 am
This is one of the questions I ask while interviewing people for a SQL Developer position.
The importance of understanding the difference between a function and a stored procedure is...
July 21, 2017 at 10:09 am
Here's one option before going to bigint.
DBCC CHECKIDENT ( 'YourTable', RESEED, -2147483648)
July 20, 2017 at 1:09 pm
July 20, 2017 at 12:46 pm
Viewing 15 posts - 1,081 through 1,095 (of 8,731 total)