This might help:

Select

(Case When Tag = 'Tag1' Then Date else NULL end) As Tag1Date,

(Case When Tag = 'Tag1' Then Value else NULL end) As Tag1Value,

(Case When Tag...

I don't think you can do that without using Dynamic SQL. If you user the following code:

Declare @Tablename1 varchar(30) = 'Test'

Declare @Tablename2 varchar(30) = 'Test1'

Select * From @tablename1 as u...

I don't know about the tool you are using....but you can do it easily by using either of the following in SQL Server:

1. Import/Export Wizard

2. Bulk Insert

capn.hector (5/3/2012)

---

not a problem. when i do these sort of things i try to think of cases where my query would break. i almost posted exactly what you...

List of .Net Forums

If imex's solution doesn't work then please post the DDL of your table and some readily consumable sample data to go with it.

Help us in helping you.

capn.hector (5/2/2012)

---

the problem with that query is the IN list contains the max interview date for...

ALTER TABLE <table_name>

DROP CONSTRAINT <Primarykey_name>

They are not saying that they could not download it.

These are real people who take out time from their busy work schedules...

What made it work??

al_yamama_1980 (5/2/2012)

---

Vinu512 I looked some thing when i go to the firwell > allwo aprogram or featrue througe widows firewell>SQL server > details the messgae appaer there is { No...

I can't think of anything that might help you...May be the pros here might have something better for you.

al_yamama_1980 (5/1/2012)

---

Hi every one

My windows server 2008 R2 and setyp SQl server 2008 when i went to coonect the ODBC the Messge appeare:

Sql state :"01000"

Sql server error:"11001"

[Microsoft] [ODBC Sql server...

Thank you very much for posting the DDL Scripts.

You would also have to post some...

Guvera (5/2/2012)

---

Hi,

I am having two tables that table name Test1 & Test2. Two tables are same and Test2 is the backup table for Test1. Now i need to do some...