I'm sure this article will help you.

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

What about using the query that Sean gave you for each database using and except between them?

select so.name as TableName, sc.name as ColumnName, t.name as DataType,

--need to divide by...

Hi,

You should help us to help you by delivering ddl and sample data in a consumable format. Because you're relatively new, I did it for you this time.

Here's a possible...

I forgot to complete the condition, it's corrected now.

kapil_kk

---

how to fetch one by one row using WHILE instead...

For what I understood, you're trying to have Users and PortalUsers for all the employees.

This should do the trick. However, you might feel more confident using the OUTPUT clause.

Be aware...

You need to get rid of that cursor. We could help you but you need to provide the code for the stored procedure.

Maybe you can do something like this:

;WITH BaseData AS (

SELECT

observ_value,

prod_id_code1,

create_timestamp,

modify_timestamp,

ROW_NUMBER() OVER (PARTITION BY person_id, obs_id ORDER BY...

Please test the solution, I might have made a mistake.

declare @Temp table(state varchar(50),county varchar(50), city varchar(50),Action varchar(50), ActDateTime DateTime)

insert into @Temp(State,County,City,Action, ActDateTime)

select 'Texas','Harris','Houston','Census Taken','11/12/2010 00:00:00' Union all

select 'Texas','Harris','Houston','Census...

For a simple solution, use a Calendar Table. There are many solutions but here is one that might help you with other queries. http://www.sqlservercentral.com/scripts/Date/68389/

With that, you can simplify your query...

I'm not an expert in this area (I'm just learning) but an advice I've read says that you shouldn't have a backup plan. You should have a recovery plan:-D.

You need...

Have you explored using Case (Cross Tabs) with ROW_NUMBER with PARTITION BY Acct_ID?

You should take a look at this article

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

Most in here would say you want to unpivot the table 😀

Create a unique constraint on the PO number

Hi, welcome to SQL Server Central.

Unfortunately, you didn't give enough details for someone to help you out.

You need provide code or at least the actions that are followed by the...

One rule you should follow is not to use code you don't understand. If you need to support it and you don't know what it's doing, you'll be in trouble.

Read...