T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Check Datetime Existence within multiple columns

  Hi there, I've a BillDate as date, and a Mark as bit column in First table. (Mark=0 by default) In …

  adnan8t2

  1 replies

  12 years, 5 months ago

  By: Bhuvnesh

• SQLSERVER 2010 into 2005

  I have a database developed in sqlserver 2010. Now i want to import it in 2005 ti view it. Is it po…

  MuhammadShafiq

  4 replies

  12 years, 5 months ago

  By: Phil Parkin

• Where condition not equal to multiple columns - PUZZLE - who can solve this?

  Concerning the puzzle below, need a SQL guru to tell me how they solved this problem. Goal: To get …

  Mach1000

  5 replies

  12 years, 5 months ago

  By: Mach1000

• Stored Proc and performance

  Is there any SQL that can be added to a Stored Proc to track if there was any blocking of its SQL, …

  dwilliscp

  12 replies

  12 years, 5 months ago

  By: Sean Pearce

• Delete rows from the table using cursor

  Hi All, I have used the cursor in the stored procedure to delete the data from the table. I'm delet…

  Nandy

  12 replies

  12 years, 5 months ago

  By: Sean Pearce

• Using PATINDEX to find all numeric values

  Hello, I forget. How can PATINDEX be used to find column values where the data is all numeric? I've…

  cdun2

  12 replies

  12 years, 5 months ago

  By: Jeff Moden

• Test results report

  I am trying to generate a report showing which questions were missed on an online test for a given …

  rdprecure

  10 replies

  12 years, 5 months ago

  By: Dwain Camps

• set row number to various actions

  I'm trying to set row numbers to a table's output. Table looks like AccountNumDataActionActi…

  Ceevei

  5 replies

  12 years, 5 months ago

  By: mister.magoo

• DatePart week and year end

  I have this in a stored procedure (SS2005): DATEPART(ww,Driver_summary.Dor_date) AS WeekNum When ru…

  pbaldy

  5 replies

  12 years, 5 months ago

  By: octagonbi

• pass table name as a parameter in stored procedure

  Hi Can I pass a table name as a stored procedure ?? when I did that, it gives me anerror saying yo…

  Nuts

  18 replies

  12 years, 5 months ago

  By: jessie 20540

• Size of all databases with create date

  How do i get this with a simple query.

  Tara-1044200

  1 replies

  12 years, 5 months ago

  By: Ant-Green

• Getting wrong amount due to date divider

  Hi, Having a hard time figuring this out. I have a query that is used for benefit deductions. We r…

  krypto69

  2 replies

  12 years, 5 months ago

  By: krypto69

• Wanting to learn. Who can best explain this in a simple yet crystal manner to a noob??

  Hi all, I am very new to T-SQL.. and i came across this: ROW_NUMBER ( ) OVER ( [ PARTITION BY …

  10e5x

  6 replies

  12 years, 5 months ago

  By: 10e5x

• sp_send_dbmail is not giving proper formate in txt attachement of SQL query output

  Hi , I have following code to execute. i want to have functionality to send email for the following…

  Megha P

  3 replies

  12 years, 5 months ago

  By: Megha P

• shrinking database

  hi all, i want to know that ,can we shrink the database at the time of working on that database. if…

  lathish2kumar

  2 replies

  12 years, 5 months ago

  By: Bhuvnesh