Viewing 15 posts - 16 through 30 (of 73 total)
am not seeing any specific error. on restore job history, it says step failed. 🙁
January 27, 2011 at 12:35 pm
Thanks Lutz.. I will let you know once it gets changed and the impact..
December 17, 2010 at 11:59 am
Thanks a lot Lutz...I just modified query and it executes like a champ...
November 12, 2010 at 6:09 am
Thanks..lets see how it goes...it would take some time to go thru processes to have this NCI...
November 10, 2010 at 12:23 pm
here goes the DDL..Only CI on PK exists..
CREATE TABLE [dbo].[Temp](
[GUID] [char](36) NOT NULL,
[fk_InventoryID] [int] NOT NULL,
[TranType] [int] NOT NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_TempAmount] DEFAULT (0),
[TimeStamp] [datetime] NOT NULL,
[Results]...
November 10, 2010 at 11:47 am
Thanks Lutz..I will work on them as you advised...
September 20, 2010 at 6:33 am
CirquedeSQLeil --- Got any clues on this?
have a great weekend...
Thanks
September 17, 2010 at 1:44 pm
Thanks for immediate resposne.. Its being called in side a huge procedure..being called inside a cursor as below.
IF dbo.CheckDayMatch(@ViewDate, @SessionFrequency) = 1
Below is the procedure ,from where the...
September 17, 2010 at 10:21 am
check if this is what yo are looking for result set1
if object_id('tb1') is not null
drop table tb1
CREATE TABLE [dbo].[tb1](
[trade] [varchar](10) NULL,
[leg] [varchar](10) NULL, -----say it is my Unique key
[ccy] [varchar](10)...
August 13, 2010 at 2:33 am
check if you are looking something like below....if not, post table defintions ,sample data and expected results to get faster and accurate responses.
if object_id('tempdb..#test123') is not null
drop table #test123
SELECT id1...
August 12, 2010 at 11:05 pm
Jeff / Jvanderberg...Thanks a lot for your explantions...
July 26, 2010 at 11:43 pm
No luck with your code..can you please generate the code which was mentioned in my first mail with your logic...
July 25, 2010 at 11:22 pm
Thanks for the reply. But this wont solve my work as my code is filtering databases in where clause while selecting the cursor..
declare CURSOR FOR SELECT [name]
...
July 25, 2010 at 11:09 pm
With the given information, it would be difficult to provide tested code , but check if following works..
--Change Below code
--IF @temp = App_ID --This is the part giving error.
--to
IF...
July 9, 2010 at 4:27 am
Viewing 15 posts - 16 through 30 (of 73 total)