84gopi (8/1/2012)

---

Hi,

I have merchandise week table in my package which contains week values wk1,wk2,wk3.....upto wk53 per year.

So using this i need to display current week as 0, for any season...

good, you are one third of the way there!

1. CREATE TABLE stuff: missing...

2. INSERT INTO stuff...missing.

3. xpected Output...attached.

a word doc or screenshots is not...

84gopi all 14 of your posts over the last 20 days are on the same subject: showing your data by weeks and ranges of weeks, in what i think is...

it's not a one to one relationship. more than one index value will be able to fit in each 8k page;

so an index will be made up of as many...

speaking of vacations, I just...

Mr. Popki nailed it;

your excellent error message shows the value 2012061414297 is being inserted into a table;

that value is larger than the max of an int:

select 2012061414297

select convert(int,2012061414297)

(1 row(s) affected)

Msg...

similar to what Jayanth suggests, something like

customer_number

+ CONVERT(varchar,row_number()

OVER (partition by customer_number

ORDER BY customer_number)

)

would work as well.

the reason is to make is a beauty of a gui/user tool.

yes for a simple add column, it's a trivial one line wonder in TSQL.

But they put logic in place...

So many great posts on this one; I'll add a couple of my own thoughts.

Managers worry that the guys who work from home put an hour at the desk, and...

beautiful correction and thank you,

I updated my snippets with a note so i remember that.

thanks!

opc.three (7/31/2012)

---

The DEFAULT option works as you described, but you'll need to set @path this way...

i had to google that one, as i never had to connect to a firebird database yet;

this page has screenshots and code that should help:

http://www.ibprovider.com/forum/site/viewtopic.php?t=19

what results do you get when you run EXEC sp_fkeys myTable?

na1774 (7/30/2012)

---

OMG. You are Amazing. Thank you very much. You were a ton of help.

I was wondering when we run this does it query the current trace file. What I...

ok, you can get whodunnit info fromt eh default trace, i just tested this:

so if not too much time has passed, you can find out who;

declare @path varchar(255)

SELECT @path =...

nope, sorry.

unless you have some sort of auditing already in place, whether a server side trace, Change Data Capture, Change Tracking, SQL Audit, or some thing like triggers or...