celine.godines (10/29/2015)

---

I thought about this but I wouldn't know how to start to be honest. I am a system tester since February only, I am getting better with SQL queries...

Try this.

celine.godines (10/29/2015)

---

Morning!!

I am doing some data gathering before 'the real deal', I am not a wiz on SQL, manage my way around but that's pretty much it, hence the use...

Excellent link and way too many Jeffs getting involved there!

Alan.B (10/28/2015)

---

Hi folks. I needed to write a stored proc that takes generates a string of random characters @minlen to @maxlen characters long for testing some functions. What I came...

And here is part 2 again, for those people who prefer their SQL formatted 🙂

declare @object_name sysname

,@object_id int

,@SQL nvarchar(max);

select @object_name = '[' + object_schema_name(o.object_id) + '].['...

No.

Now I suggest you change your...

Don Shoemaker (10/28/2015)

---

We are running SQL 2014 SP1. We are using defined Full text indexes on several tables in the database. However, on one specific set of servers,...

celine.godines (10/28/2015)

---

It will be for multiple customers (I have about over 1000000)

All customers have different products and different Names/Values... (and not always 2 products and 6 names, it will varies)

I...

OK, I understand. But will there be the same number of columns for every customer, or will the number of columns vary depending on the number of products for each...

celine.godines (10/28/2015)

---

I have the following results:

CustomerProductName ValueChargesNewCharges

13AZ 40005056

13BY 30023

13BX 50003536

13BW 16001312

13BV 107009392

13BU 7000109110

And would like to...

revanappa.shivanagi (10/28/2015)

---

Hi,

In my SSIS package , I have changed one of table column name from upper case to lower case for Ex."EMPLOYEEID" to "employeeid".

After changing case i am facing an...

Thanks Steve, I didn't know about this. Very useful.

shkoli (10/27/2015)

---

CREATE TABLE [dbo].[Managements](

[ManagementId] [int] NOT NULL,

[FTAManagementNo] [varchar](35) NULL

)

CREATE TABLE [dbo].[MgmtCountries](

[MgmtCountryId] [int] not null,

[CountryId] [int] null,

[ManagementId] [int] null ,

[FTAManagementNo] [varchar](35) NULL

)

i want to get only those ManangementId which is available...

Have a read here and see whether that helps you at all.