Viewing 15 posts - 466 through 480 (of 5,502 total)
paramjit4 (4/6/2012)
is it will work on sql server
Why don't you give it a try? :unsure:
April 6, 2012 at 3:14 am
Does the trigger return any data (e.g. due to a SELECT statement left over from debugging)?
Can you post the code for the trigger?
April 6, 2012 at 3:02 am
Can you post the query you're using together with the exact error message?
April 6, 2012 at 2:56 am
Assuming you have a Tally table (see the related link in my signature if you don't know what that is) you could use this table in an OUTER APPLY query.
If...
April 6, 2012 at 2:52 am
Your question can't be answered in a forum post.
Especially the term "in general" could be broken down into the following subsections:
Hardware (e.g. slow spindles, network issues,...)
Overutilization of hardware (heavy load...
April 6, 2012 at 2:34 am
Since this is the 2008 forum I didn't even consider 2012 syntax as being an option. 😉
Even if, I wouldn't be surprised if the new syntax would perform less efficient...
April 1, 2012 at 9:32 am
duplicate post. No replies plese.
Please repond using the original thread
@Larry: Posting the same question multiple times does not only fragment the answers. It might also lead to duplicate answers (=...
April 1, 2012 at 8:42 am
Something like this?
DECLARE @Task TABLE
(
DESCRIPTION CHAR(5),
DueDate DATETIME
)
INSERT INTO @Task
SELECT 'Task1','2012-03-30' UNION ALL
SELECT 'Task2','2012-03-31' UNION ALL
SELECT 'Task3','2012-04-01' UNION ALL
SELECT 'Task4','2012-04-02' UNION ALL
SELECT 'Task5','2012-04-03' UNION ALL
SELECT 'Task6','2012-04-04' UNION ALL
SELECT 'Task7','2012-04-05'
DECLARE @RAG...
April 1, 2012 at 8:33 am
Shouldn't be Task4 show Amber then? (It's "between" amber and green)
April 1, 2012 at 8:09 am
Why should Task2 return Amber?
Why NULL for Task 6 and 7?
April 1, 2012 at 7:32 am
Using SQL Server it would be a little more tricky:
DECLARE @tbl TABLE
(
Name VARCHAR(30),
Dept VARCHAR(30),
Enddate DATETIME
)
SET DATEFORMAT mdy
INSERT INTO @tbl
VALUES
('Bill','Shipping','01/20/2009'),
('Bill','Receiving','05/15/2010'),
('Bill','Accounting','03/28/2011'),
('Sara','FInance','05/14/2010'),
('Sara','Shipping','10/11/2011')
;
WITH cte AS
(
SELECT *, ROW_NUMBER() OVER(PARTITION...
April 1, 2012 at 6:44 am
Are you looking for something like this?
DECLARE @table1 TABLE
(
id INT IDENTITY(1,1),
DateOfBirth DATETIME
)
INSERT INTO @table1
SELECT '20060331' UNION ALL
SELECT '20060401' UNION ALL...
April 1, 2012 at 6:23 am
Ronnie Jones (3/27/2012)
Thank you for all of your responses on this issue. I've been at this all...
March 27, 2012 at 3:07 pm
Is it possible the .dat file is Unix based?
In that case a line feed is .
But when using BULK INSERT, it silently add \r to it, causing the error.
There are...
March 27, 2012 at 2:51 pm
March 27, 2012 at 10:42 am
Viewing 15 posts - 466 through 480 (of 5,502 total)