Viewing 15 posts - 4,366 through 4,380 (of 5,504 total)
My knowledge regarding SSIS is limited but I'd guess the mapping would still try to convert it to a date format...
I'm not sure if a stored SSIS package would recognize...
February 2, 2010 at 2:11 pm
GSquared (2/2/2010)
MS Access is excellent for that. Link it to the SQL server, query building can be all drag-and-drop and clicking, without writing a line of code. ...
I thought...
February 2, 2010 at 2:07 pm
WayneS (2/2/2010)
And yet, if you look at the last line of the OPs original post, this is exactly what he wants.... for now.
So, do you think having a persisted calculated...
February 2, 2010 at 12:09 pm
sql_ques (2/2/2010)
SELECT LASTNAME FROM CPM.dbo.T_CANADIANWHERE '678567' BETWEEN '673001' AND '679000'
AND 'Z' BETWEEN 'P' AND 'P'
this worked.
I actually doubt that this query would return anything but an empty result...
February 2, 2010 at 9:59 am
If you try to save it as a view then you'd need to remove the semicolon from the beginning of the statement, since it actually is the end of the...
February 1, 2010 at 3:54 pm
Why would you need a function?
If you want to return all [emp id fk], simply remove "and [emp id fk] = 4" from your statement and you'll get the...
February 1, 2010 at 3:07 pm
Lynn Pettis (2/1/2010)
Stumbled onto the thread the Lutz was talking about. Steve took care of the sample data.
Please note my statement from one of my previous posts 😉
Any correlation...
February 1, 2010 at 3:00 pm
Seems like the data are part of a customer list(!!).
The effect on a single company is minor, I think.
But it seems to be a trust/loyality issue between each of the...
February 1, 2010 at 2:32 pm
Thank you for sharing your thoughts!!
@luke: no security related data. Otherwise I most probably would have voted for option b. Basically just address information. But his address is one of...
February 1, 2010 at 2:15 pm
Ok, here's the summary of a short mail conversation I had in between:
How to open Template Explorer in SSMS:
a) CTRL+ALT+T
b) Menu-> View-> upper section 4th item
Issues I had when trying...
February 1, 2010 at 2:01 pm
I'm struggling with a little ethical issue:
Let's assume you find the contact information of a company a friend of yours is working for in some sample data posted on the...
February 1, 2010 at 1:50 pm
Using Lowells sample:
SELECT * FROM MYTABLE
--betweent eh date and the date plus three months
--WHERE MYDATEFIELD BETWEEN @DateParameter and dateadd(month,3,@DateParameter )
WHERE MYDATEFIELD > DateParameter
AND MYDATEFIELD <=dateadd(month,3,@DateParameter )
February 1, 2010 at 1:01 pm
You could wrap the GROUP BY into a subquery or a CTE and join that to your base table.
I didn't know the number of columns nor do I know if...
February 1, 2010 at 12:58 pm
Don't you think requesting to rewrite/optimize 400 lines of code crosses the line between forum help and consulting?
I personally think it does.
Howerver, here's something to start with:
To set your @Include*...
February 1, 2010 at 12:55 pm
You could store the data in an intermediate table with a VARCHAR(max) column and use the WRITE function to get rid of the first and last character.
Then split the remaining...
February 1, 2010 at 12:40 pm
Viewing 15 posts - 4,366 through 4,380 (of 5,504 total)