Grass (2/28/2013)

---

Hi all,

Trying to get data by month for current month and previous month in ssrs but couldn't able to get it. I was using this statement in procedure:

IF @CurrentDate...

Comes down to if the scalar function is being called once per query or once per row in the query.

To accomplish a point in time restore you need the STOPAT = 'datetime' as part of the RESTORE LOG command.

Here is a link to MSDN: http://msdn.microsoft.com/en-us/library/ms186858(v=sql.100).aspx

I'll let others provide more info, but from what I have been learning, don't always put much credence in those values.

To accomplish a point in time recovery. You this clause when you want to restore a database to a specific point in time, prehaps to capture data that was...

This is from MSDN regarding DBCC CLEANTABLE:

DBCC CLEANTABLE reclaims space after a variable-length column is dropped. A variable-length column can be one of the following data types: varchar, nvarchar, varchar(max),...

IIRC an instance can have only one mirror...

Please read the first article I reference below in my signature block. Follow the instructions in that article regarding what you should post and how to post it to...

Why not explain exactly what it is you are trying to accomplish? I have no idea so I have no idea what to tell you until you can provide...

Not sure how to do it in SSIS but in T-SQL:

CONVERT(VARCHAR(8),MyDateCol, 112)

Can you convert it prior to SSIS doing its thing?

Well, if we could see what was running on the server when PLE drops we might be able to help you out, unfortunately we can't see it.

One guess would be...

daglugub 60457 (2/27/2013)

---

So I set the rowcount to 1 in a query session.....but now I can't get more than 1 row to return. How can I turn it back...

insanityflyff (2/27/2013)

---

well i wrote it like this right now

DELETE FROM [CHARACTER_01_DBF].[dbo].GUILD_MEMBER_TBL WHERE NOT EXISTS (SELECT (m_idPlayer) COLLATE DATABASE_DEFAULT FROM [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL])

hopefully this will be better

and about the loop thing i...

You may also want to read this article: http://www.sqlservercentral.com/articles/T-SQL/67898/.

Look at using LEFT OUTER JOINS and either ISNULL (SQL Server specific) or COALESCE (ANSI Standard).