Viewing 15 posts - 46 through 60 (of 3,666 total)
JALLYKAMOZE (8/25/2016)
Alvin Ramard (8/25/2016)
CREATE TABLE DELAYSECONDS(
ProgramID INT, ID INT, ContractHeaderID INT...
August 25, 2016 at 10:31 am
It would also help if you provided us with proper information. The SQL logic you provided does not work!
CREATE TABLE DELAYSECONDS(
ProgramID INT, ID INT, ContractHeaderID INT StationID INT ContractStartTime...
August 25, 2016 at 10:18 am
Would this work?
LEFT(REPLACE(CAST(NEWID () AS NVARCHAR(MAX)), '-', '') , 15)
August 25, 2016 at 10:10 am
Phil, do we currently have a full moon? :w00t:
August 25, 2016 at 9:54 am
Those CASE statements with the REPLACE??? They make me question if you understand what you're trying to do.
August 24, 2016 at 2:11 pm
What exactly are you trying to do? Remember, we can't read your mind. We can only provide answers based on what you tell us.
August 24, 2016 at 7:41 am
In your CASE statement, try changing "pr.hours" to "CAST(pr.hours as decimal(38,2))".
August 12, 2016 at 9:24 am
If he's that lazy, he should forget about SQL 2016 and get started on SQL 2018! 😛
August 11, 2016 at 7:20 am
John1.5.nlt (5/16/2016)
So why dont...
May 16, 2016 at 3:41 pm
John1.5.nlt (5/16/2016)
Why would this statement not recognize the schema name as the schema and utilize it as part of the table name, the table name is ABC.aTabletemp
Don't expect answers without...
May 16, 2016 at 3:24 pm
Kinda hard for anyone to have any idea without seeing the script.
May 16, 2016 at 2:44 pm
Luis Cazares (5/9/2016)
You'll be missing any holidays. To prevent that, you'll need to create a calendar table or at least a holidays table.
I normally use the Dim_Date table from the...
May 9, 2016 at 11:03 am
Sean Lange (4/26/2016)
Lynn Pettis (4/26/2016)
Sean Lange (4/26/2016)
Alvin Ramard (4/26/2016)
Ed Wagner (4/26/2016)
Luis Cazares (4/26/2016)
Wonder if I should answer: "Using INSERT statements"http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx
Well, you would be correct. Tell them to create the...
April 26, 2016 at 2:00 pm
Ed Wagner (4/26/2016)
Luis Cazares (4/26/2016)
Wonder if I should answer: "Using INSERT statements"http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx
Well, you would be correct. Tell them to create the table first. 😉
Tempted to reply with: "Tell your...
April 26, 2016 at 12:56 pm
New persopn (4/26/2016)
Currently I am capturing Audit information in to file.
I didn't where. I asked how?
April 26, 2016 at 12:52 pm
Viewing 15 posts - 46 through 60 (of 3,666 total)