SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Triggers not working correctly

  I have a table A which has an insert,update and delete trigger which inserts updates and deletes va…

  Pink123

  1 replies

  13 years, 2 months ago

  By: GSquared

• Next 3 Months

  I have a column which has months (1 --> 12). In my result set I want to show all the data for th…

  Sachin 80451

  10 replies

  13 years, 2 months ago

  By: Sean Lange

• Using Update with SET joining on 2 tables not producing correct results

  Hi, I have 2 tables: Table1 Fields: name, dob, dos, ssn, ssn_match, dob_match, dos_match Table2 Fi…

  elizabeth.shields 75607

  1 replies

  13 years, 2 months ago

  By: Dwain Camps

• Sum value for same sub_id with different id

  Hello, i hope you can help me. I have the following table. declare @table3 table(n int,p int,t floa…

  igngua

  4 replies

  13 years, 2 months ago

  By: igngua

• Counting Query Results that have the same value in multiple columns

  I would like to write a query that only shows results when certain columns display the same result …

  dustinprevatt

  3 replies

  13 years, 2 months ago

  By: Lynn Pettis

• Need Help with CURDATE Query

  Here is the query I am working with. select * from table where cast (postdate AS int(128)) between …

  dustinprevatt

  9 replies

  13 years, 2 months ago

  By: Sean Lange

• An Instance related error

  Hi i'm using SQL server 2008 that was working well. Today when i tried to connect with the server i…

  mschotamaster

  5 replies

  13 years, 2 months ago

  By: george sibbald

• If Username in Result set update another table.

  Hi, I need a hint for getting to the solution. I have two table : 1.Bankroll (User the in casino an…

  yanivkahana10

  2 replies

  13 years, 3 months ago

  By: yanivkahana10

• Condensing 2 output rows into 1 via SQL Query

  I need to create a query to take the data below and create one row query result. Actual Data Outp…

  jvalentine 25324

  3 replies

  13 years, 3 months ago

  By: Sean Lange

• Keep Track of 10 Password's History Table.

  Hi, I Have 2 table : The first Contain's : Username , Password, firstname etc'... I need to build …

  yanivkahana10

  6 replies

  13 years, 3 months ago

  By: yanivkahana10

• Yes I will need to Hash them.

  Thank you ! I didn't thought about it this way!!

  yanivkahana10

  1 replies

  13 years, 3 months ago

  By: Sean Lange

• Returning everything through a left outer join

  I have the following script, does anyone have clue where I have gone wrong? I currently only have d…

  Sachin 80451

  1 replies

  13 years, 3 months ago

  By: Gail Shaw

• Stored Procedures and Web Services

  Hello to all! Here I am again. Seeking the knowledge of the mightiest DBAs. I have a stored proce…

  johnnycash

  3 replies

  13 years, 3 months ago

  By: Evil Kraig F

• How to handle/manipulate the results of a stored procedure called from another stored procedure

  Hello to all you gurus! Newbie to the max here! I have a stored procedure that returns a dataset (…

  johnnycash

  2 replies

  13 years, 3 months ago

  By: johnnycash

• Generate insert statement from table

  Hi, I want to move data from one node to another. Data is corrupted by developers , so I can't move…

  thbaig

  7 replies

  13 years, 3 months ago

  By: thbaig