you have to make sure ALL of your variables are the same (nvarchar(max))

Truncation when concatenating depends on datatype.

if you do something like this:

nvarchar(max) + varchar(n)

SQL will first convert the...

mailtoashokberwal (11/27/2013)

---

Any suggestion on below:

I need to compare two strings which have comma separated ISO Country codes.

For example : String1 = '356,840'

...

if not too much time has passed, it will be in the default trace;

but the default trace only keeps a rolling history of 100 meg, so it could get pushed...

ok, flexing my Google-Fu a little bit, i found this article that might help; it claims to find long running jobs in 2000-2008 versions:

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AgentLongRunning

I don't have a 2000 server to test agaisnt, but assuming...

hunchback (11/26/2013)

---

There is no harm by having both expressions but having "LastDate <> '19000101'" is enough to cover both cases "is not NULL and is diff from '19000101'".

WHERE ...

...

ok, a kewl sneaky way taking advantage of parsename

Declare @TableName varchar(128) ='ABCD_kkk_DDD'

SELECT PARSENAME(REPLACE(@TableName,'_','.'),2)

and the long drawn out way:

Declare @TableName varchar(128) ='ABCD_kkk_DDD'

SELECT SUBSTRING(@TableName,0,CHARINDEX('_',@TableName)) As Pt1,

REPLACE(@TableName,SUBSTRING(@TableName,0,CHARINDEX('_',@TableName))+'_','') As Inprogress,

SUBSTRING(REPLACE(@TableName,SUBSTRING(@TableName,0,CHARINDEX('_',@TableName))+'_',''),0,CHARINDEX('_',REPLACE(@TableName,SUBSTRING(@TableName,0,CHARINDEX('_',@TableName))+'_','')))

As Part2

there's nothing wrong with receiving that warning; some of the data you are looking at is null, and that's normal; some data has never been updated, only origianlly inserted is...

as far as i know, if you try to run chkdsk on a disk that is active in any way, it will tell you it cannot do it.

if it was...

test for the data with an exists:

IF EXISTS( SELECT 1 from test1 WHERE sl_code=@cd AND DATEDIFF(DAY,doc_dt,GETDATE())=0) )

BEGIN

DECLARE @htmlbody VARCHAR(4000)

SET @htmlbody = 'This is a Simple Email...

vignesh.ms (11/26/2013)

---

Hi There,

I need to ensure some naming standards to users while creating tables.

All table name should be in same pattern

(ie., ) TeamName_EmpId_tablename

I need a way to restrict...

sorry, no loop required;

you need to create a semicolon delimited list of the files, including the full path.

this worked for me:

CREATE TABLE #files(File_Name varchar(200), depth int, fil int)

INSERT #files

EXEC master.dbo.xp_dirtree...

i see how to show/hide columns based on wether they are exported or not here:

https://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr8

but i don't see how to filter based on the export type yet.

Skypass (11/25/2013)

---

Hi,

How do I attach all files in a network folder to an e-mail (without zipping) using sp_send_dbmail.

The names and number of files in the folder will keep changing. ...

this link will probably help enourmously, and keep you from granting sysadmin rights when it's not required:

Microsoft.com:Configure a User to Create and Manage SQL Server Agent Jobs