If it works for you, then is fine. If you want to continue to work with SQL, you should start trying to do it "the right way" because this DB...

I wouldn't because it won't, it will just cause performance issues.

I'd create an inLine Table-valued function.

CREATE FUNCTION dbo.ReturnOnlyChars(

@String varchar(8000)--...

Can you post the code you're using?

You shouldn't have problems, but if you do, you might want to CAST all your int columns into decimal(13,4). You might also have an...

Here are two options.

DECLARE @Codes TABLE

(

Codes VARCHAR(10)

)

INSERT INTO @Codes

( Codes )

VALUES ('ABC-0350'), ('DEF-00430')

SELECT Codes,

STUFF(Codes, 1, CHARINDEX('-', Codes), ''),

SUBSTRING(Codes, CHARINDEX('-', Codes) + 1, 8000)

FROM @Codes

Have you tested again?

For some performance improvement you could pre-aggregate your data. Note that I'm suming the counts but is still a count.

SELECT [date],

SUM( CASE WHEN typesold = 1 THEN amount ELSE 0...

That's the point. A table...

I'm not sure what you need without DDL, sample data and expected results.

However, those articles have the basic theory to pivot queries both static and dynamic.

For more help, please read...

It's possible, take a look at this articles:

Cross Tabs: Part 1[/url]

Cross Tabs: Part 2[/url]

Then you'll need to cast as bigint before multiplying.

(CAST( YEAR(getdate()) AS bigint) *10000000)

Why do you need a value like this anyway? What's your serial column data type?

You have to add the column list to the table you're inserting into.

insert into [AdventureWorks2012].[Sales].[SalesOrderDetail]( <Column list goes here>)

values(43665, 1, 'HkTest', 25, 715, 1, 25.00, 5.00, 25.00, 'B207C96D-D9E6-402B-8470-2CC176C42283', getdate());

Eugene Elutin (2/11/2014)

---

2. I wouldn't rename your "pivot" column as it may be used under that name by many calling processes. In this case you will need to change them...

Have you tried Central Management Servers?

http://blogs.technet.com/b/lobapps/archive/2013/01/01/manage-multi-servers-effectively-using-sql-server-central-management-server-cms.aspx

The problem is that '0000000' is being converted to int and adding it to the year. Instead of converting th char and then to int, I would just use some...

You could as well right-click the database, go to Tasks-> Generate Scripts... and it will help you to script all the objects you need from the db.