by default, all columns are added to the end to a table; to add one in the middle, you have to rebuild the whole table.

SQL doesn't care about column order...

just use a case statement to check for the number of periods; if it's two or more, use your formula, else get the full string.

typical results:

Node1.Node2

Node1.Node2

Node1.Node2

ServerName.DatabaseName

192.168

Bob

code example:

select

CASE

...

i didn't see this thread, and started building my response before Jason posted the cross post info.

a Normal view is not materialized as data the way a table is;

views get...

edited to avoid crossposting the post as Jason suggested. see the original thread.

I might be misreading your requirement, but what i guess that was what i was trying to say....

you have access to the remote server, right?

if you do, then you can...

i see;

can't you go to the remote server, find the role that your user mydomainname\username is in, and then jsut add a SQL login to the same role?

then that logon...

Eric can you show us the proc text itself, and maybe post the execution plan of the proc when it runs? that would give us the critical diagnostic info, i...

Jeff Moden (1/7/2010)

---

If it's a fixed field (no delimiters, each column a given width), then I just import into a single column flat table and do a simple substring split....

the trick is to use a combination of dateadd and datediff, here's sme examples of some firsts and lasts; to apply the logic to a specific daye, like "what...

there are a lot of options for linked server security; i've only used three ways, which i'll try to explain:

1: anyone accessing the linked server uses a specific logon from...

i think you are looking for the LUHN mod 10 credit card validation, right? googling "TSQL LUHN mod 10"

got me this tsql code snippet"

http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-47-udf_Bank_IsLuhn.htm

it looks like you have not added the PAYEE_ID yet:

ALTER TABLE #PAYEES

--add first item: column

ADD PAYEE_ID INT NOT NULL,

--add second item: constraint

CONSTRAINT PK_payeeID PRIMARY KEY CLUSTERED (PAYEE_ID) ...

i copied and pasted the example, and it works fine; it might be the case-sensitive collation of your database...i noticed i spelled it "tally" in one spot, and "Tally" in...

both of these syntaxes worked fine for me, against know tables for me; i don't get the syntax error you were using

ALTER TABLE [dbo].[MYTBL1] ADD DEFAULT (getdate()) FOR [APPLDT]

ALTER TABLE...

i believe you are correct, you can use it to find non latin characters. I'd need to test it against more varied data; is it working for you as expected?...