select stuff((select ';' + Mobile from [YourUn-namedTable] order by Num FOR XML PATH('')),1,1,'')

If this doesn't get you what you're looking for, please take a look at the first link in...

sihaab (2/11/2010)

---

How can I script include columns from the index.

We can script Table Name of the Index, Index columns of the Index but how do we script include columns...

sqlserver12345 (2/10/2010)

---

With CTE .... in sql 2000 gives me a syntax error...any other way of doing this ?

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the...

The only problem with this is that you do not get the actual error message... you will get the variable holders in the string in sysmessages, instead of the actual...

Here's one method. The tally table that Lutz mentioned would also be very efficient.

-- first, notice how I create a table and populate it with the test data?

-- This makes...

you know, I do seem to recall reading something somewhere about an undocumented command that might let you recover a database from a backup made after the database got hosed......

In case this helps anyone else, here are the amazon links to these books:

"Information Modeling and Relational Databases" by Terry Halpin

"Practical Issues in Data Management" by Fabian Pascal

C.J.Date's "Relational Database...

David,

Thanks for taking the time to make these recommendations.

On your first question of the datetime/smalldatetime... you need to look at how the underlying data is stored. Both are stored as a real number... for instance,

select convert(datetime, 12345.785215)

returns...

sounds like you need something like:

DECLARE @SourceA TABLE (

[ServerName] [varchar](50) NULL,

127.0.0.1 [varchar](50) NULL

)

DECLARE @SourceB TABLE (

[ServerName] [varchar](50) NULL,

127.0.0.1 [varchar](50) NULL

)

-- insert the sample data

-- notice how it's in...

probably because those tables were scripted out without the extended properties, then when run...

CirquedeSQLeil (2/9/2010)

---

Those two tables, no. They are tweener tables. They were technically shipped with SQL...

select *

from sys.tables

where is_ms_shipped = 0

SQL Dude-467553 (2/9/2010)

---

Is this login for a 3rd party application? I ask because I discovered an interesting issue with MS Dynamics that uses SQL Logins for each user version...

Schadenfreude-Mei (2/8/2010)

---

Might be to do the local keyboard/language set on the remote system.

Set up another remote machin with vpn and try that, bu if other users are fine, then its...