Viewing 15 posts - 4,726 through 4,740 (of 7,191 total)
Would you not just remove a column from the input?
John
February 10, 2012 at 3:57 am
I can't work out what your question is here. The way to use multiple CTEs is like this:
WITH CTE1 AS (
SELECT...
FROM...
WHERE...
), CTE2 AS (
SELECT...
FROM...
WHERE...
)
<Now use your CTEs here the...
February 10, 2012 at 2:37 am
Documented here
http://msdn.microsoft.com/en-US/library/ms177523(v=sql.90).aspx
In the section "Using UPDATE with the FROM Clause"
Thanks Mark - I knew it must be in there somewhere.
John might also like to read the BOL entry below which...
February 8, 2012 at 9:25 am
surely its down to the developer / administrator to realise that there is no guarantee what value will be used in the update.
Precisely. Would you use that syntax if...
February 8, 2012 at 8:40 am
Yes, but the point is that with UPDATE...FROM, you'll never know about it. If you use the ANSI syntax, you'll get an error message.
John
February 8, 2012 at 7:46 am
Here's where Joe explained it to me before. I now try to avoid UPDATE...FROM unless there is no possibility of cardinality errors - and then I document it in...
February 8, 2012 at 7:31 am
If you can't find it in SSMS, it's probably because you don't have enough permissions on SQL Server. If you log on to the server and run SQL Server...
February 8, 2012 at 2:13 am
You need MSSQL$APP1.
John
February 8, 2012 at 1:45 am
alex.newsum (2/7/2012)
But I do not understand why a date is automatically pulled in this long format with the dates outside the text query.
It might have something to do with...
February 7, 2012 at 7:29 am
Debbie
Instead of using an Execute SQL task to get the result set into an Object variable, why not use a Data Flow task to get it into a staging table?...
February 7, 2012 at 4:04 am
An index enforcing a primary key constraint will indeed be created clustered by default, but if there is already a clustered index on the table, the new index will be...
February 7, 2012 at 3:58 am
Almost.... since a function was required, and you can't use temp tables in a function:
CREATE TABLE testitem (itm_item varchar(43) NOT NULL,itm_desc varchar(100) NOT NULL,wsd_quantity int NOT NULL)
INSERT INTO testitem
SELECT 'CHCWPSU10DMX','Chroma-Q...
February 6, 2012 at 6:09 am
It sounds as if the file was in the wrong place and the registry entry was correct, since you said that everything was 64-bit.
John
February 6, 2012 at 5:00 am
OS error 5 means access denied, while OS error 2 means the file could not be found. Looks like permissions have been changed in one place and elsewhere, one...
February 6, 2012 at 3:57 am
Bhimraj
Then you won't be able to release any space from your log file. You have two options:
(1) Implement your new backup strategy as a matter of priority
(2) Switch to...
February 6, 2012 at 2:50 am
Viewing 15 posts - 4,726 through 4,740 (of 7,191 total)