Are you trying to insert the entire PDF into a column in a table in your database? It's not entirely clear from your post.

Interesting... Thanks Sean and Luis for the gentle "schooling". I'll have to add that to my SSC database (the stuff I brazenly steal from here... hey, gotta learn somehow!)

Maybe I...

Nitin,

The short answer to your question is to use DelimitedSplit8K[/url] to split the text strings into different columns and then deal with those.

This was my first try splitting (just so...

Glenn,

any chance you could provide a create table script and some dummy records? Are all the records in the same table?

thanks,

Pieter

Oh, I understand now. You wanted to change the color of the individual values on the timeline/X-axis when the value is on a weekend. Don't know how to do...

" I can tell consistently when the parameter dropdown list will have values and when it will not have values."

how? psychic powers?

Could it be a timeout?

Watch Kendra Little's video[/url]...

See #6. and the video that goes with it.

She and Brent Ozar know more about SQL Server than I probably ever will. And they know what they're...

Exercise your Google-fu. Found a bunch of hits in less than a second.

sys.dm_os_volume_stats - see example A.

An example from SQLMag...

Sounds like you might need a report or something that...

Olaf,

I got it to work, sort of. (Well, in my bar graph.)

I created a simple bar graph with (Date, Value), so the x-axis represents dates. If you right-click on a...

Nice solution, but where did OrderDate go?

I did the query in 2012 (Yes, I did read that you were using 2008... solution to follow) This was the SQL statement - super easy once Windowing functions...

Maybe start here:

https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

Since this is a guessing game without the CREATE TABLE and INSERT scripts and the expected results, please provide them. I'm just not a fan of pin the tail...

Can't remember if this works in 2008. I think it works in R2

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH,OUT_PUNCH,HOURS) AS

(

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3' ...

Welcome to SSC...

For a first timer, pretty good post. Two things that would help us to help you are:

1. CREATE TABLE scripts

2. INSERT scripts to populate the table(s)

so...