You're welcome!

CREATE TABLE SCCTest (Col1 INT, Col2 INT, Col3 INT)

INSERT INTO SCCTest (Col1, Col2, Col3) VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9)

SELECT * FROM SCCTest

SELECT * INTO...

Ah! Then you need to be introduced to the INTO Clause 😉

I would use HTML to output your results. Looks much better when sending in email too.

In fact I was doing something like this last Friday and here is the code...

Use Jeff Moden's string splitter function. See link below (the function can be found in a zip file at the end of the article)

Tally OH! An Improved SQL 8K “CSV...

ganeshc27 (11/15/2013)

---

The column on which the NCI is created, is being used in the WHERE conditions in the queries post this Index creation. How do I find whether this NCI...

ROFL.....

I think I've had this error when connecting to a SQL 2012 instance using the wrong version of SSMS. Are you using the 2012 SSMS version to connect?

Can I suggest you start with the obvious and chose appropriate data types for your columns?

CREATE TABLE #tbl_ChannelViewCost

(

rcc_id NUMERIC(10,0),

activity_dataset_id NUMERIC(10,0),

profit_centre_id NUMERIC(10,0),

channel_dataset_id NUMERIC(10,0),

customer_dataset_id NUMERIC(10,0),

product_category_dataset_id NUMERIC(10,0),

channel_cost NUMERIC(22,8),

driver_id NUMERIC(5,0),

)

Why are you...

Cross-posting is frowned upon here I'm afraid!

All replies redirect to : http://www.sqlservercentral.com/Forums/Topic1512602-392-1.aspx

Welcome to SCC Surya!

Please use the search box to find plenty of articles on this topic.

Here is one I found for you. Hope it helps.

http://www.sqlservercentral.com/articles/T-SQL/67202/

Let's hope you've got fast disks:-)

How come you haven't mentioned disaster recovery strategy? That's pretty important IMHO.

We went through a similar exercise some months ago and I had to provide the IT manager with a...

No it's not a stupid question at all. You may have to write sprocs to record this information in audit tables as TRIGGERS will not do the job. I updated...

Something like this:

CREATE TABLE dbo.SCC (

Col1 VARCHAr(10),

Col2 INT,

Col3 INT,

Col4 TINYINT)

INSERT INTO dbo.SCC (Col1, Col2, Col3, Col4)

VALUES ('Test1', 3016482, 56395, 1), ('Test1', 3016482, 56395, 2),

('Test2', 5489108, 57921, 2),

('Test2', 5489108, 57921,...

You may have one SQL login for the app but you must be maintaining a users table somewhere in your database.

If that is the case then you can write custom...