Viewing 15 posts - 1,171 through 1,185 (of 1,468 total)
Do you understand the code?
CONCAT is simply a method to concatenate a number of string (or values that can be implicitly converted to string) values.
How...
April 18, 2017 at 10:23 pm
How do you respond to his latest response that an experienced person is...
April 18, 2017 at 1:01 pm
April 18, 2017 at 6:24 am
reported as spam
April 18, 2017 at 12:15 am
mw112009 - Monday, April 17, 2017 3:11 PMShould be an easy one right ?
I like it in YYYYMMDD format
This will get the...
April 17, 2017 at 3:19 pm
There were a couple of comments I had...
April 17, 2017 at 2:58 pm
This should get you going ....
CREATE TABLE #Data (
empno int
, jobid int
, vesselno int
,...
April 17, 2017 at 12:31 pm
This should give you the results that you are looking for.
CREATE TABLE #TEMP (
ID Int
, Executed_Time Time
, Schedule_Days...
April 17, 2017 at 4:15 am
The way I see it, is that this table is a single source of resource contention. It has only 1 record, that is updated for every transaction (8 different types). NOTHING...
April 17, 2017 at 3:57 am
April 17, 2017 at 3:46 am
Thanks Jeff. The likes, etc makes sense.
Agreed - This site always comes up with great answers. Especially when "POOR" code is posted, as somebody always points out a...
April 14, 2017 at 12:55 am
It's because you have a GO statement in your code.
When you try to create the proc, the GO statement tells SQL that you are finished with the proc, and...
April 13, 2017 at 2:59 pm
April 13, 2017 at 1:06 pm
April 13, 2017 at 7:19 am
i have a very simple control table with 1 record, this record manages number...
April 13, 2017 at 6:05 am
Viewing 15 posts - 1,171 through 1,185 (of 1,468 total)