Forum Replies Created
Viewing 15 posts - 25,606 through 25,620 (of 26,487 total)
-
RE: why parameter inclusion causes less records
Because NULL is not like @GL + '%'. You are now filtering your result. If you what all values to meet your filter or where GRPLDR.GLPerson is null, you need...
-
RE: How to notify a person when there''''s an update done to a table
I concur, as SQL Mail can be flaky at times.
-
RE: Index Precedence
SELECT
'x'
FROM
MyDB1..table1 a
INNER JOIN MyDB2..table2 b ON
a.SubsidiaryNo = b.SubsidiaryNo
is your query, but I don't see a.SubsidiaryNo in any of the indexes for table 1. This may be why it...
-
RE: Reseed doesn''''t change column properties?
Interesting. Of course, I've never had to do to what you needed, so I wouldn't have even thought of the NoResees. something to keep in the back of mind (as...
-
RE: help with dynamic SQL
Can you also post your DDL for the tables involved?
-
RE: Reseed doesn''''t change column properties?
Because the DBCC CheckIdent is not modifying the metadata used to create the table, it is simply resetting the starting seed number to be used for future inserts into the...
-
RE: Date Math
How about the DDL for the table(s) and some sample data?
-
RE: Using the IBM OLE DB Provider for DB2
You need to install the ODBC driver on the server.
-
RE: Date Math
Try this :
where mb_membership.mbr_renew_date >= dateadd
(mm,datediff(mm,0,
-
RE: Date Math
To clarify, if @startmonth = 2007-07-15, you want all records where mb_membership.mbr_renew_date >= 2007-07-1 and mb_membership.mbr_renew_date < 2007-08-01?
-
RE: Help using IN operator for passed list in parameter
Like I said earlier, looks like you will need to use dynamic sql. Build your query into a string, @SQLCmd = ...
then execute that, exec (@SQLCmd)
I was just hoping...
-
RE: Stop the madness
Steve, Combine to two threads on Bankers Round and you get close (depending on how you round :rolleyes
-
RE: Stop the madness
Cause I am tired of the personal attacks for the most part. It's gotten to the point it isn't worth debating with some people.
url: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=383658#bm385709
-
RE: Select Top n Query
Give this a try:
create table dbo.MyTable (
JobNo decimal(6,0),
Status char(2),
TransDate datetime,
RecordId bigint identity(1,1)
)
go
insert into dbo.MyTable values (1234,'AB','01/07/07')
insert into dbo.MyTable values (1234,'AB','02/07/07')
insert into dbo.MyTable values (1234,'AB','03/07/07')
insert into dbo.MyTable...
-
RE: Backup Log file failure
What is the recover mode for the database?
Viewing 15 posts - 25,606 through 25,620 (of 26,487 total)