Viewing 15 posts - 46 through 60 (of 164 total)
Chris (12/10/2008)
Hi eshan this is not a one time process i need to do it evryday so it should take the date itself....
YesChris, you told this earlier. Here is the...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 11, 2008 at 3:22 pm
Check the below article for more info on it.
The GO Command and the Semicolon Terminator[/url]
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 11, 2008 at 9:27 am
pbreitenbeck Posted Dec 10, 2008 @ 4:47 PM
SSC Veteran -
I basically understand everything in the block of code below, except the last two lines. I understand that...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 11, 2008 at 8:49 am
You can do this by constructing a dynamic query using the PIVOT operator. You can take help from the article in the below link in doing it.
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 10, 2008 at 2:15 pm
DATE(12/04) DATE(12/05) DATE(12/06)
Are these the only dates in the DATE column in the table
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 10, 2008 at 12:28 pm
timscronin , you can use PIVOT clause for this solution if you are on SQL Server 2005 as follows. I notice that your table allergy has a column patientid but...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 10, 2008 at 10:14 am
Try this and let know this is what you require. Note that you should provide sample data and script for better response.
create table MachineName (machineName varchar(50), machineID int)
insert into MachineName...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 9, 2008 at 3:45 pm
I am really thankful to you Paul for your reply and alleviating my concern. It prompts me to explore more this 'B-tree structure' thing, quoted so much in the BOL...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 4, 2008 at 3:49 pm
Thank you very much Paul for your elaboration. However, I have just one doubt.
Paul Randal 12/4/2008 10:50 AM
-------------------------------------------------------------------
It's not a B-tree (either the classic B-tree, or the B+-tree that...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 4, 2008 at 10:12 am
ntext and bvarchar(max) can store the same amount of data (2 GB maximum or a 16-bytes pointer).
I fact SQL 2005 has depreciated the NTEXT in favor of NVARCHAR(MAX), though NTEXT...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 4, 2008 at 6:13 am
Ah yes. You'll need to join the inserted table to the source table, otherwise the insert will try to insert all rows from the table to the destination....
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 4, 2008 at 3:45 am
nazaninahmady_sh,
INSERT INTO DBntext2.dbo.Destination (Id, Title, Body)
SELECT Id, Title, CAST(Body as nvarchar (MAX))
FROM DBnetxt1
The problem here is that you are missing the table name after the FROM...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 4, 2008 at 3:03 am
steveb is right. Following is the sql for the solution provided by him. In fact I missed this idea earlier. I am just modifying his idea a little. There is...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
November 27, 2008 at 9:35 am
You can split the data out into two seperate staging tables, one for Firstname and One for LastName
Then use another dataflow to load these both up and join them...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
November 27, 2008 at 8:40 am
Thanks, Jeff. Will this work for a normal/unprivileged user also?
This will work if the user has at least the 'CONNECT' role
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
November 11, 2008 at 12:43 am
Viewing 15 posts - 46 through 60 (of 164 total)