dlangschied (2/27/2013)

---

I needed to export some data from SQL 2000 database to Excel. I only needed a portion of two of the tables, so I generated as a Visual...

great jo providing the setup data!

Here's another fast way using the PARSENAME function;

PARSENAME is usually used to split object names, like ServerName.Databasename.dbo.TableName,

but can be used for IP address and...

YSL i put this together in a different post, it scripts out all your database mail settings;

for me this is handy when i want to winmerge and look for subtle...

MDX is nothing i've played with, but my google fu pointed me here:

http://www.google.com/search?q=mdx+bitwise+operations

and that seems to say you've got to add some .net toys? because MDX does not do bitwise...

but two years would be 730 days (365 x 2?), not 2, right?

DELETE FROM incident WHERE DATEDIFF(DD, CAST(getdate AS DATE), created) > 730

another thing to consider is to search any sourcecode for object names;

we have plenty of "functionality" that exists in various application, but noone ever uses the functions in real life;

As...

monilps (2/26/2013)

---

Hey,

Thank you for quick response

What I meant was

For Ex:

Row1: aaaaaaa 02/20/2002 jjjjjj sddsdjjjjsdsd sdsds

Row2: asdlajsd fjsdfjkdgn dsjbfks, dfjksflml,fsf,f sdfsdf 9/3/99 sjdfnsdnf sjdfoisofn

Row3: sdkfjos fjsdopfj uyro dlsfl 02-02-02...

it'll take a bit of work, and you'll need the DelimitedSplit8K function (search SSC and read the article)

things like 02/02 and 02-02 are not dates, so they do not get...

possible, but i wouldn't recommend it; deletes should be decided based on some analysis, and not just because a table might contain a columname that matches or something. Additionally, you...

if you use SET XACT_ABORT ON, you can make the code a little easier to read; if any error occurs, it stops the process and rollsback the transaction automatically:

each delete...

you might get a benefit out of it, but it's one of those one half of one percent kind of things, and not a major performance enhancements.

remember what has to...

you choose New Login, and then use the find object to find a windows group....once you are in there, it becomes more clear:

nothing happens automatically, so something is changing the setting.

if you restore a database, the property for autoclose is stored inside it, so that's one possibility....restore it,and since the last setting...

• This reply was modified 7 years ago by Lowell.
• This reply was modified 5 years, 9 months ago by Dave Convery.

no.

the case statement stops executing as soon as a match is...

the title of your post "In --> Group By with Multiple columns...> how it will responds " is not enough for us to go by;

can you explain...