if you are trying to find the consecutive records from start to some row that equals the amount, this solution below using a "running total" works;

if you are after some...

Well at least it's not me;

they can make a views for the oh so heavily queried sys.routes and sys.schemas but not a sys.functions;

seems more like an oversight rather than a...

I agree with Howard;

I'll bet it's parameter sniffing with out of date statistics also, and the recompile of the procedure because you made some text changes(but no functional change:...

what have you tried so far? because this is your first post and your example has the word "student" in it, we want to make sure you learn the...

you need to install the oracle client on the Server that is hosting the SQL Server instance.

you'll have to copy/set up the TNS names files just as you would any...

anitha also watch your data types...if the column is CHAR or NCHAR, it is padded on the right with spaces to the full size of the column definition: insert 'anitha'...

i thought it was one of those implicit conversion things;

when your WHERE is evaluated here:

id = '';

the id column is implicitly converted to varchar....since every int can convert to a...

this is probably the easiest way: using the LIKE statement and the pseudo regular expression:

select zipcode,* from YourTable where zipcode like '%[^0-9]%'

that will find anything with characters outside of the...

the issue is datatypes; integers/number datatypes do not have preceeeding zeros;

i think your table dbo.ReportFinal.MedRecNO is defined as an integer;

you said it's defined as an nvarchar, but that's the only...

Ray it's easy to do, but trying to do it in TSQL is not a good implementation.

TSQL's the wrong tool for this job.

I'd say it's much better and easier to...

if you move the alter into an EXEC statement, it will work:

If Not Exists(Select column_name From information_schema.columns

Where column_name = 'InsertedDateTime'

And table_name = 'RecipEligToVendorErr')

Begin

Begin Transaction

EXEC('Alter Table RecipEligToVendorErr

Add InsertedDateTime DateTime...

some of it is your order of operations:

you are replacing this first:

replace(billtoaddress1, 'PTE I', 'PT')

replace(billtoaddress1, 'PTE II', 'PT')

replace(billtoaddress1, 'PTE III', 'PT')

so the end result is PTEII

that's not what you...

some of this may be beyond my ability to explain it, but here goes:

a TEXT or IMAGE datatype fields can store something like 2 gig of characters; it's variable...

both your tables have a column named "NAME" of the datatype TEXT:

..Name TEXT NOT NULL ,...

those data types are stored in a different way; a pointer is stored and the...

lol the redirect thread has more posts than the thread we should reply to.