I've recently had to work with some MySQL databases and I think the core engine is fine (although the optimiser is very simplistic, so it's better for basic CRUD than...

That's certainly true for T-SQL UDFs.

Technically speaking a CLR UDF could affect pretty much anything it wanted, it would just be a bad idea as you have no guarantee...

Not sure I follow any of this advice. CPU and Memory are entirely different resources and the amount you'll require of each before you hit contention will depend on your...

It's easy...

This looks like a running total problem to me (with multiplications as opposed to additions). Most set-like solutions are going to run into some pretty horrendous triangular joins quite quickly....

The literal of double-quote in an SSIS expression is \" (backslash double-quote) as double-quote is reserved. Is that what you're after?

E.g. REPLACE([expression],"\"',"")

But why don't you just explicitly set the...

Vedran Kesegic (4/19/2012)

---

Yes, but CTE bring limitations: it wont work in a view, and it works on less SQL versions that without CTE. So, my choice is to use a...

opc.three (4/19/2012)

---

itskanchanhere (4/19/2012)

---

I used Teradata SQL Assistant client to execute some procedures in SQL Server. Since these had Print statements they failed...Sps without print were successfully executed.. I faced problem...

SELECT TOP 10 ItemNo,Name,COUNT(ItemNo) AS TheCount FROM Table1

GROUP BY Division,ItemNo,Name

order by COUNT(ItemNo) desc

Edit: Sorry, just saw for each division.

Something like this should steer you in the right direction (untested...

Ignore system variables. They don't have anything to do with your FTP task username. The values aren't stored in variables, they're stored in the properties of the connection manager (this...

There are a few options here.

If you're using variables because you want to reference the value of the variable in multiple locations (e.g. a servername etc. that may be used...

There's a good video here about getting started with Profiler:

http://technet.microsoft.com/en-us/sqlserver/ee861095

=Dateadd("d",-1,Today())

Stefan Krzywicki (4/11/2012)

---

I had to complain about this somewhere.

I'm creating a visio diagram for the database behind a commercial product. There's a lot wrong with this database, but we've just...

If JobID is sequential and always starting from 1, then you could use something like this:

-- create example table Jobs

CREATE TABLE #Jobs (ID INT, Name NVARCHAR(16))

INSERT INTO #Jobs VALUES (1,'Job...