1
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • Objects explorator FILTER doesn’t work, SQL Server Management Studio de sql server 2008

    Hello friends, On my PC (Windows Xp 2002 SP3) in SQL-Server management studio 2008, the object explorator filter doesn't work. The funnel symbol is simply greyed. I can't access to the box bialog filter parameters. Please, anybody has an idea ? Jean-Max PS : Microsoft SQL Server Management Studio...

    Poussines50 pointsBadges:
  • SQL select loop list?

    Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...

    Vinical5 pointsBadges:
  • How to automatically update Child Table with Insert Trigger and Table-UDF

    I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be a...

    Ironryan775 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following