Viewing 15 posts - 18,196 through 18,210 (of 59,069 total)
PHXHoward (3/4/2016)
I think that the suggestions to explicitly format the data that is going into the varchar(10) column will solve the problem. It is really...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 11:54 am
John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.John
Got code?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 11:50 am
etl2016 (3/4/2016)
But, its a bit more programming, involving local-scoped variables, some Queries, some aggregation and a final result.
Can we say something like, SELECT col1, col2, (DECLARE local_variable INT; SET @local_variable...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 11:49 am
Phil Parkin (3/4/2016)
a) Modifying one long and complex piece of code, and
b) Modifying several small and well-organised pieces of code, where the function of...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 11:47 am
Luis Cazares (3/3/2016)
For more information about iTVFs and how they compare with normal scalar functions, check this article written by...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 7:44 am
tcronin 95651 (3/4/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 7:40 am
bismsit.29 (3/4/2016)
this is a new table which will get offer feed from...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 7:21 am
tcronin 95651 (3/4/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 6:55 am
mandymvn (3/3/2016)
"do you want the report headings to auto-magically change based on today's date (whatever it is)?"
is there a way to do it ? I am not sure If...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2016 at 12:08 am
bismsit.29 (3/3/2016)
I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 6:22 pm
mandymvn (3/3/2016)
At present am showing quarters from 2015-Q1 to Q4 , it should be like that, because report must show data for last 4 quarters only.
Whenever i got...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 6:15 pm
fxferguson (3/3/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 6:10 pm
TJT (3/3/2016)
Hi SSCoach, do you have an example of a holding table? Also do you have an example of retrieving data from the " inserted or deleted virtual tables"?
You...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 6:09 pm
...and thing like this...
WHERE (DATEDIFF(D, sod.ConfirmDate, GETDATE()) > 0)
... make it impossible to do index seeks and generally slow code way down because it has to calculate for every...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 6:01 pm
tcronin 95651 (3/3/2016)
Started with 300 gig tempdb, may need to expand that.
I can't really tell because I know nothing about your databases but that seems a bit much. I've...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 3, 2016 at 5:52 pm
Viewing 15 posts - 18,196 through 18,210 (of 59,069 total)