GREAT job providing the setup.

in this case, since you have to check for two values,, i think you want to join the table against itself.

you can join the same table...

I'm under the impression that Express with advanced tools installs the SQL and SSRS, but also installs a small version of Visual Studio, with the templates for creating SSIS packages...

I carry LinqPad around on a thumb drive if i happen to wander to a desk without my favorite tools.

you can install an unlimited number of SQL Server Management Studio...

I've never gotten a DSN-less Access linked server to work.

the link below will get you rolling, but if you have Office installed on your local machine, a side affect is...

I misread your question as moving off of the Os drive, insteadof what you asked;;;

so should tempdb.mdf be T:\tempdb.mdf vs T:\SQLData\tempdb.mdf ?

i'd say folders make things more organized, so...

i would use a view that does the calculation from your post above, and then you can poll the view instead of the base table. that is the easiest route,...

scotsditch (9/15/2015)

---

Hi I'm trying to create a temp table using the script below and it's taking forever. I was hoping someone might have some tips on hows I could...

As a remember it, there is no valid syntax for ALTER TYPE. only drop and create.

i know that once a user type is in use, to change it, it cannot...

could you have a script out there that tries to be bulletproof, and drops and recreates the linked server before it does any work, in order to guarantee, for that...

to fix @@servername, modify this example to the "right' name

while the changes are in the right tables, it will eventually require a stop and start of the SQL services...

it is not possible to rename an instance name. only the server itself.

so on my local machine named [LowellDev], i have LowellDev\SQL2014, LowellDev\SQL2012 and LowellDev\SQL2008R2 instances.

if i rename my...

here's my guess on the requirements,i thought of two ways to do it, but i was not sure if you could have the same Id multiple times, all with the[IS_NULL]...

no input, just consumable data to help:

;WITH EstimatedData([QuarterDate],[sf_115],[sf_315],[sf_415],[sf_515],[sf_615],[sf_915],[sf_1015],[sf_1115],[sf_1215])

AS

(

SELECT CONVERT(DATETIME,'01-15 -2015'),'1',NULL,NULL,NULL,NULL,'1',NULL,'1',NULL UNION ALL

SELECT '12-15-2015',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1' UNION ALL

SELECT '09-30-2015',NULL,'1',NULL,'1',NULL,'1',NULL,'1',NULL

)

SELECT QuarterDate,

sf_115,

...

can you make an assumption based on the length? your example using charindex of the left parenthesis doesn't match your sample you posted.

;WITH MyCTE([PostalCode])

AS

(

SELECT 'Derbyshire S42 5BX' UNION ALL

SELECT 'NN4...

Help us help you!

if you can provide your sample data in a consumable format(meaning copy and paste to SSMS and build the data)

as well as the queries you are running...