PiMané (10/4/2012)

---

Hi,

Is it safe to say that XML data type should be used to store data, instead of creating more columns on the table, data that won't be searched. If...

You think it didn't work or...

I agree this process sounds like it was not well designed. How do you handle things like credit card rejections or simply typing in bad info? By that point the...

You do realize this thread is 5 years...

Another great article is here. http://www.sqlservercentral.com/articles/Performance/71549/%5B/url%5D

And for what it is worth the NOLOCK hint is not a magic go fast pill. It comes with a lot of other concerns, like...

SQLSACT (10/4/2012)

---

Hi All

I understand that parameter sniffing is a good thing

It becomes a bad thing when the parameters used in the first execution of the Procedure are atypical to the...

Here is an example of doing this both ways:

First is the Delimited string method. The code for the DelimitedSplit8K function can be found at the link in my signature about...

What you need to do is either use a table valued parameter or change your datatype to a varchar and then split the variable inside the proc.

If your...

Not to sound rude but have tried (insert your search engine of choice)???

L' Eomot Inversé (10/4/2012)

---

Sean Lange (10/3/2012)

---

NO LIKE is not SARGable so you will get scans. It has to examine every row...

haiao2000 (10/3/2012)

---

And if you want to avoid the natural tendency to do some sort of looping to build your dynamic sql you can do something like this.

select 'insert YourNewTable select'...

These three payment methods have different data requirements:

1. Checks only need Payment Amount and Check Number (for our requirements).

2. ACH transactions only need Bank Name, Routing Number and Account...

haiao2000 (10/3/2012)

---

this is code to get columns name from a table,

SELECT COLUMN_NAME FROM SourceDbName.dbo.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='';

if you want to do all in sql, them you may have to build...

jrichards54 (10/2/2012)

---

I currently have VS 2003, VS 2005 and SQL Server 2005 installed on my machine. VS 2003 is 32 bit, VS 2005 And SQL Server 2005 are 64 bit....

surma.sql (10/3/2012)

---

ok, i got it.

But in my requirement, I insert the output to another table and...