Potso (8/31/2012)

---

Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure is run so...

Eugene Elutin (8/31/2012)

---

dwain.c (8/31/2012)

---

Eugene Elutin (8/31/2012)

---

If you really like the challenge, this one for you:

draw Mona Lisa using T-SQL (I remember I had seen assembler application which would print out...

Okay.

SELECT *

FROM (

SELECT '......................' UNION ALL

SELECT '......................' UNION ALL

SELECT '......########........' UNION ALL

SELECT '.....##...#.###.......' UNION ALL

SELECT '.....#..#...###.......' UNION ALL

SELECT '.....#..##..###.......' UNION...

Start by setting...

denis.gendera (8/31/2012)

---

I've got following query

select machine_id, MONTHS =

CASE

WHEN DATEDIFF("m", firstseen, getdate()) = 0 then 'AUG'

...

Here's another way:

;WITH Locations AS (

SELECT

DATEADD(dd, 0, DATEDIFF(dd, 0, createdate)) AS createdate,

COUNT(DATEADD(dd, 0, DATEDIFF(dd, 0, createdate))) AS totalcount,

sum(case channel when 'website' then 1 else 0 end) as WebsiteViews,

sum(case channel...

You will need to set up some sample data for this, there's a link in my sig to a great article which shows you how it's done.

Without knowing how...

You don't appear to need dynamic sql for this:

SELECT

--app.id,

edit.project_name

FROM tracker app

INNER JOIN edit edit

ON app.id=edit.id

WHERE edit.project_name LIKE ('%' + REPLACE(@project_name,'*','%') + '%')

sivajii (8/31/2012)

---

ti is providing output like this when i execute this proc

[1|cricket, 1| bowling&fielding, 2| batting] [2|football, 4| foul]

but the out put should be like...

No, the entire set of rows matching the search predicates are identified...

Check the collation of the target column - it may be different from the database default.

Have you checked the date today Barry? 😛

RBarryYoung (8/30/2012)

---

The real problem here though is that the OP never confirmed if the table names actually exist in the database. None of these three tricks will work if...

dwain.c (8/30/2012)

---

A man of few words! I...

SELECT

m.[Definition],

d.TABLE_NAME

FROM sys.sql_modules m

OUTER APPLY (

SELECT TABLE_NAME

FROM YourDatabase.INFORMATION_SCHEMA.TABLES t

WHERE m.definition LIKE '%'+t.TABLE_NAME+'%'

GROUP BY TABLE_NAME

) d

Edit: changed db name