Viewing 15 posts - 4,366 through 4,380 (of 5,109 total)
you should also ensure that you provide your dates in a format that anyone can use. Your dates wouldn't work my end as there's not 13 months in the year. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 27, 2017 at 2:31 am
It's IF <expr> BEGIN, not BEGIN IF <expr>
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 9:38 am
int, bigint, smallint, and tinyint (Transact-SQL).
BIGINT (-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)) can store a much larger number than INT (-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)) can, but uses double...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 9:16 am
BWFC - Thursday, January 26, 2017 8:40 AMIt's better, but if CELKO catches you, don't say you weren't warned 😀
Eh, I do sometimes...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 8:43 am
This is part of the reason why SQL is call an RDMS ( Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 8:36 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 8:34 am
Your result is to be expected, as you're not defining any JOINs. SQL needs to now what records are related to what, otherwise it has no idea.
It this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 8:02 am
Out of interest, why would you want to store these in a table? If your data changes, this would mean that your table of student ID's would be stale, and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 6:01 am
Check your column's hidden settings. It will have a setting that has the cell you are clicking set to hide or show it.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 5:36 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 26, 2017 at 2:37 am
Seeing the full query now means that there's a lot of places this could be falling over. Although I said start with the above columns, upon seeing the above, you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 25, 2017 at 9:44 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 25, 2017 at 9:08 am
The problem is that one of your columns contains a value that cannot be converted to a numeric. Your attempts above won't solve this (in this case stating a conversion...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 25, 2017 at 8:48 am
Doh. it was me using an incorrect query. You are correct.
I was doing:
[code...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 25, 2017 at 7:34 am
Right. That makes sense.
I need to learn more about CTE.
Only thing with what you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 25, 2017 at 7:15 am
Viewing 15 posts - 4,366 through 4,380 (of 5,109 total)