Yeah expanding scope can make things like that happen. You just keep extending and extending until at some point (which I guess is now) it just needs to be reworked...

NO, there are not translations for all characters.

You have to either use a datetime variable or put your string representation inside single quotes.

select * from TICKET where createDate > '4/1/2012'

Nope.

http://msdn.microsoft.com/en-us/library/bb510625%28v=sql.105%29.aspx

Not really sure why it matters if it is inside a stored proc or not anyway. The syntax...

It may run somewhat acceptably fast on the other databases but the performance gain needed from the sql engine will make those other pages scream too. This seems to be...

Murphy'sLaw (4/4/2012)

---

Jack Corbett (4/4/2012)

---

The error is telling you that you have unicode characters in the source and you are losing them when converting to non-unicode. It isn't...

I have found that the Entity Framework can generate some absolutely horrible sql. The argument of not using sprocs is rather silly. The Entity Framework can use sprocs with little...

Lynn Pettis (4/4/2012)

---

Or when...

capn.hector (4/4/2012)

---

davidandrews13 (4/4/2012)

---

ok. thats weird.

my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.

Here are...

And to be honest your 4000ms is entirely too slow anyway. Basically you are trying to get your process back to an unacceptably slow speed. This means at best your...

BWAA HAAA HAAA!!!!!

dwain.c (4/3/2012)

---

Old or new, this is pretty easy:

DECLARE @d TABLE (data VARCHAR(max))

INSERT INTO @d (data)

SELECT 'AIT_FIT_projecto and moonbeat'

UNION ALL SELECT 'AIT_FIT_projectofile where handled'

UNION ALL SELECT 'AIT_FIT_pritibabe every way'

SELECT SUBSTRING(data, 1,...

I get you wanting to learn SSIS but this task seems like a no brainer for the undocumented proc sp_msforeachdb. The problem in using SSIS is you need a different...

Try taking a look at this link. There is no reason you can't handle UNICODE data in sql server. Keep in mind there are not always direct translations from UNICODE...

Sure there are lots of people around here willing to help. First however you need to help us help you. We need ddl, sample data and desired output. Details about...