Viewing 15 posts - 211 through 225 (of 8,731 total)
February 13, 2019 at 2:13 pm
I just noticed that there's sample data posted now. Here's a solution that will pivot the data.
WITH Unpivoted AS(
SELECT *, ROW_NUMBER() OVER( PARTITION BY...
February 13, 2019 at 9:40 am
February 13, 2019 at 8:32 am
February 12, 2019 at 1:27 pm
The only thing that I could be happening is with the large gender column on your temp table. Maybe you have some non-visible characters in there.
Here's an example:
February 12, 2019 at 12:01 pm
February 12, 2019 at 11:32 am
February 12, 2019 at 7:23 am
Please post the table definitions for NAME_MASTER, temp_ad_act_20190208 and BIOGRAPH_MASTER. Or at least post the definitions of the columns used.
This has probably nothing to do with your problem, but I...
February 12, 2019 at 7:16 am
Some problems occured during an ALTER TABLE ALTER COLUMN statement.
My SQL Server Instance...
February 12, 2019 at 7:03 am
Here are the formulas to get the values you want. It's basically adding weeks to known dates. I'm using days instead of weeks to be able to add or substract...
February 11, 2019 at 1:42 pm
February 11, 2019 at 11:42 am
Raghavender Chavva - Monday, February 11, 2019 10:49 AMLet me know consumable format means ?
Read the articles linked in my signature...
February 11, 2019 at 11:13 am
Could you please help me in get the script for below scenario:
Orginal Table...
February 11, 2019 at 10:34 am
February 8, 2019 at 12:01 pm
February 8, 2019 at 7:59 am
Viewing 15 posts - 211 through 225 (of 8,731 total)