[font="Verdana"]It seems that the relation between Table: tblProduct and Table: tblProductSizeWidthColor is Parent - Child and before inserting records into tblProduct you are verifying whether the records is not...

[font="Verdana"]

Toreador (5/27/2009)

---

Look more carefully - the second query is 'GROUP BY ManagerID' and...

[font="Verdana"]Answer should be 1, 2 and 4 as well as 2nd and 4th query are same.

Mahesh[/font]

[font="Verdana"]Hi John,

Here is my last question. What seetings do I need to turn on / off while calling a job inside SProc? what thing I need to take care? Does...

[font="Verdana"]

Thanks John, OPENROWSET method works....

[font="Verdana"]Thanks again John. However its still throwing the below error

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 67

An INSERT EXEC statement cannot be nested.

Mahesh

[/font]

[font="Verdana"]Thanks John,

Further I tried to create hash table. But actually sp_help_job SPorc returns 4 resultsets. I tried like

Insert Into #JobDetails

Exec sp_help_job Null, 'job_name'

However it is throwing following error:

Core...

[font="Verdana"]Thank you,

Mahesh[/font]

[font="Verdana"]Hi All,

Atleast can anybody let me know, what things to be consider while optimizing SSIS package? What things to be consider for deploying SSIS package from one server to another...

[font="Verdana"]

Create Table #Table

(

valint

)

Go

Select val From #Table

Go

Declare @valint

Select @val

Go

Declare @valint

Set @val = Null

Select @val

Go

Declare @valint

Select@val = Null From #Table

Select@val

Go

Declare @valint

Select@val = val From #Table

Select@val

Go

Declare @valint

Select@val = (Select val From #Table)

Select@val

Go

Drop Table...

[font="Verdana"]I think you are looking for a tool like RapidSQL. You will have separate window TAB for result and for queries. However it is tremendously slow as compared to MS...

[font="Verdana"]Better you place your SProc inside DTS and here you can pass the paramenters runtime to the SProc. Then schedule the DTS.

Mahesh[/font]

[font="Verdana"]

amadriaga (3/25/2009)

---

Hey folks,

I need some expert advice. I have two tables, one 'Order' table and one 'OrderDetails' table. The 'Order' table store information about the order (Customer name, Phone number...

[font="Verdana"]

sandhyarao49 (3/25/2009)

---

Hi All,

I have written some sql queries for insertion and updation of the records on a table.

Before executing the query how can I make sure the query that I...

[font="Verdana"]Hi,

I tried the below things:

1. I added the below method

objReportViewer.PrintDialog()

2. Even thogh it was not working. Then I uninstalled Windows 2000 Hotfix – KB956390. It start popping up the Print...