You have a common solution that is used more often than you would expect.

However, I have a question for you. Do you want a complete solution or just what...

Are you crazy?

Alan.B (7/18/2013)

---

You can. It's hard to work with what you posted so I created the following sample code to demonstrate how you would join two tables in the way you...

No, you can't because the alias doesn't exist when the JOIN is processed.

More info: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/70efeffe-76b9-4b7e-b4a1-ba53f5d21916/order-of-execution-of-sql-queries

It's justified, but my approach is shorter. Maybe I'm just lazy. 😀

What do you get when you do this?

SELECT B.Date

FROM A

INNER JOIN B

ON A.ID = B.ID

WHERE A.ID < 0

You need to find out if there are any invalid dates in your...

You could use something like this.

DECLARE @sql varchar(8000) = ''

SELECT @sql = @sql + 'SELECT * FROM ' + QUOTENAME(name) + '..Docs WHERE (VirusStatus > 0) AND (VirusStatus IS NOT...

In the original function it's returned as ItemNumber instead of PosNo

Have you tried the 8K Splitter[/url]?

If there are no leading zeroes for one digit day, here's an alternative.

SELECT CONVERT( datetime2, PARSENAME(OraDate,4) + ':' + PARSENAME(OraDate,3) + ':' + PARSENAME(OraDate,2) + '.' + PARSENAME(OraDate,1))

FROM (SELECT '25-JUN-13...

Like this?

SELECT CONVERT( datetime2, STUFF(STUFF(OraDate,13,1,':'),16,1,':'))

FROM (SELECT '25-JUN-13 12.01.15.096000000 AM' AS OraDate) O

You can Unpivot your table to be able to join it.

CREATE TABLE #Overtime_Budget_2013(

[Org_Level] [nvarchar](50) NULL,

[Overtime Code] [nchar](10) NULL,

[January] [money] NULL,

[February] [money] NULL,

[March] [money] NULL

)

INSERT Into #Overtime_Budget_2013(Org_Level, [Overtime Code], January, February,...

Voide (7/17/2013)

---

riya_dave (7/17/2013)

---

hi

my query is giving me erro

delete top(1000) from table a

join table b

on a.id = b.id

and b.date < getdate()

error: incorrect syntax near a.

i want to delete top 1000...

There's no need for an ORDER BY if the ultimate goal is to delete all the rows that follow that condition. However, a cycle will be needed. It's common to...

Use DATENAME