Viewing 15 posts - 3,301 through 3,315 (of 5,109 total)
This is one solution. One point, if you are storing a time, store it as a time not a varchar, then you can do date math...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 8:00 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 7:11 am
Pictures don't really help. DDL of your table would be great, as I would expect a column of integers to be of the data type intrusion. You won't be able...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 6:37 am
schleep - Friday, August 11, 2017 5:08 AMYep.
"Yep"? There have been several questions asked before your post. Which one(s) are you answer(ing)?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 5:14 am
Soooo, is Microsoft changing the SQL Server "Enforce password policy," "Enforce password expiration" stuff anytime...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 4:40 am
I'm not really sure that SQL server is going to be the right answer for this. I assume that you can use an unlimited amount of the numbers, so in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 3:36 am
You can't align an image, no. You'll need to size your image box to the correct size of the image, and place it is the appropriate location.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 3:17 am
The enrollmentID key is not used by any queries in my company. That column...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 3:02 am
Honestly, I have no real idea what your requirement is here, apart from it seems you want to change a column with the value POSOURCE!A!!16 to POSOURCE!A!!xxx16. I'm...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 11, 2017 at 2:41 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 2:18 pm
This script works good, but in my environment I have 100 dbs so I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 10:05 am
Have a look at: http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 9:14 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 8:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 8:05 am
UNION is working exactly as intended. UNION doesn't add columns to a dataset, it adds further rows.
Without knowing your data this is a guess, but perhaps...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 7:15 am
Viewing 15 posts - 3,301 through 3,315 (of 5,109 total)