Boyan Penev (2/26/2009)

---

There is another way to apply "styles" to a report - by storing the report attributes, such as colour, in a database table and then retrieving them in...

Nice circular reference there Chris 😀

Whens your next TV show coming out?

you can match on User plus the space

replace(columnname, "User ", Employee ")

or you can change the userid part of the string first, then revert afterwards

replace(replace(replace(columnname, "UserID", "UxSxExRxIxDx"), "User", "Employee"), "UxSxExRxIxDx",...

mh, your solution is fine but when you test it with a lot of data against a cursor, the cursor is orders of magnitude faster

I adapted your query to fit...

doesn't sound like a valid CSV file

are the text columns quoted or not?

e.g. does the file look like this

1,"company name","this is a description,company in USA"

or is it

1,company name,this is a...

declare @milli as int

set @milli = 11202079

select @milli/3600000 as hours,

(@milli - ((@milli/3600000)*3600000))/60000 as minutes,

...

Save first

right click the package, select copy

right click the SSIS Packages folder, select paste

Right click new package, select rename.. rename package (don't forget the .dtsx extension) and click yes when...

I think you'll need to get your typing hat on.

As far as I know there is no way to copy variables from one package to another. Each variable is...

garethmann101 (2/24/2009)

---

I assume that once a website is launched on a remote host, the only real way to update the database (add fields, tables, etc.) is to do it directly...

The problem with these sorts of calculations is that a row of data in a database is completely independant. It does not know or care about its neighbours and so...

Where is the stored procedure being called from?

If it is from another stored procedure then why create the list and then seperate them?

You can use a temp table to store...

if you want to avoid using lots and lots of ORs or you don't know how many strings you need to check before you run the query then try a...

You can use Visual Studio as a SQL editor

This gives you greater control over the file structure of the solution and allows you to connect to a source control...

simplest way is to build a function to handle it

function will need to loop backwards through the string to find the last "\"

once you have that location you can work...

ricol (12/5/2008)

---

Always these silly remarks about performance... Hey we are not kids, during night shift 95% of all SQL-Servers sleep if they are not filled up with silly IS-stuff copying...