Viewing 15 posts - 3,991 through 4,005 (of 5,502 total)
If you need to figure out where you have different results in your two tables then just use the great sample code Paul provided, join it to your invoice header...
March 13, 2010 at 4:05 am
I'm not sure if I'm missing the point but to me it seems more like the question is:
Why is the DROP TABLE statement not recognized?
As far as I know you...
March 13, 2010 at 4:00 am
Why do you have MAY 2nd in your list instead of May 1st?
What data format is your dt column?
Please help us help you.
March 13, 2010 at 3:45 am
Please see BOL (BooksOnline, the SQL Server help system usually installed toegther with SQL Server) section "CONVERT".
March 12, 2010 at 5:01 pm
Like I wrote before:
UPDATE targetTable
Set Col=value
FROM SourceTable
INNER JOIN TargetTable ON JoinCondition.
You don't need to go for each bottle separately... 😉
So, forget about using a cursor for this task. It's not...
March 12, 2010 at 4:22 pm
scott.atkins (3/12/2010)
Regarding what i have just wrote, im trying to piece together a Cursor that allows me to retrieve information from one Table and update another table below you...
March 12, 2010 at 3:27 pm
Elliott W (3/12/2010)
Also, I would really have to think about allowing users to run SSIS packages as themselves in a production environment. I'd have to see a heck of...
March 12, 2010 at 3:13 pm
One option would be to set up a staging table you could use for your bulk load task and add a stored proc to insert those data into the final...
March 12, 2010 at 3:04 pm
You're welcome! 😀
Going back to the picture you used:
Sometimes it's faster to just cut the tree rather than just barking up... 😉
March 12, 2010 at 1:56 pm
I guess the answer is "it depends".
But there's one thing I wouldn't do: using sp_send_dbmail directly within a trigger, since the mail sending process would become part of the insert...
March 12, 2010 at 1:54 pm
Don't think about a specific user. Do it set based:
INSERT INTO [db].[dbo].[ProfileUsers]
([PROFILE],
...
March 12, 2010 at 1:23 pm
I'd rather use an inline table-valued function (ITVF)...
CREATE FUNCTION [dbo].[GetMonths](@StartDate DATETIME, @EndDate DATETIME)
RETURNS TABLE
AS
RETURN
(
SELECT DATEADD(mm,number,@StartDate) AS MonthValue
FROM master.dbo.spt_values
WHERE TYPE ='P'
AND number<=DATEDIFF(mm,@StartDate,@EndDate)
);
March 12, 2010 at 12:52 pm
i have around 3000 "or cb.emailaddress1 like" filters on it
It's not really a good design to hardcode all those or conditions. Create a separate table holding those values and join...
March 12, 2010 at 11:26 am
Please see my answer posted on your parallel thread.
...
March 12, 2010 at 11:15 am
Once you captured the id values from the first insert you need to join it to the secon xml statement. Something like the following:
;WITH cte AS
(
SELECT
a.b.value('routeh[1]','smallint') troutehidx,
...
March 12, 2010 at 10:27 am
Viewing 15 posts - 3,991 through 4,005 (of 5,502 total)