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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2016 at 10:18 am
Would this work?
LEFT(REPLACE(CAST(NEWID () AS NVARCHAR(MAX)), '-', '') , 15)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2016 at 10:10 am
Phil, do we currently have a full moon? :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 24, 2016 at 7:41 am
In your CASE statement, try changing "pr.hours" to "CAST(pr.hours as decimal(38,2))".
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 12, 2016 at 9:24 am
If he's that lazy, he should forget about SQL 2016 and get started on SQL 2018! 😛
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2016 at 7:20 am
John1.5.nlt (5/16/2016)
So why dont...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 16, 2016 at 3:24 pm
Kinda hard for anyone to have any idea without seeing the script.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 26, 2016 at 12:52 pm
Viewing 15 posts - 46 through 60 (of 3,666 total)