Hi Bob,

why don't you set up a view on your SQL Server containing all information you need (department info and record count)?

Therewith you wouldn't have to worry about doing two...

duplicate post.

Discussion already started here.

duplicate post.

Discussion already started here.

edit: system forced a double post...

duplicate post.

Discussion already started here.

You might want to put some more confidence in this community! 😉

There...

Since Albania submitted an apply for admission to the EU, you'd be faced with European (minimum) standards in terms of taxes a.s.o. sooner or later.

If you'd do your payroll system...

What is the "target system" of your 25Mill rows? (flat file, different database/system, maybe even SSMS (???))

What are you trying to do with that rather large amount of data (=...

vblllove (7/6/2009)

---

This Payroll System will not be apply to USA System. This will be in Europe. That's why we need a Unique System since the most of Software system are...

@ Jack: that's pretty much exactly...

Hi,

if I'd have ready to use data s describe in my signature (as well as in the sig of many other posters on this forum) I might be able to...

duplicate post. (please don't cross post.)

original post: http://www.sqlservercentral.com/Forums/FindPost747776.aspx

Hi VampireGhost,

Thank you for providing the sample data in a ready to use format! Good job! 🙂

Regarding the SELECT statement:

Instead of using the IN clause I'd rather use something like:

SELECT...

Hi Digs,

I'm just curious:

Have you ever tried the DelimitedSplit function as per this post?

If yes, then you'd have noticed there always have been two columns...

When looking at the...

Hi Matt,

as you probably figured it's hard to verbally describe a database scenario with just a few words...

It's also hard for some of us to "draw the picture".

Maybe you could...