Kindly post some details around this. Your question is not very clear.

Seems new to the forum, please go through SSC Best practices for getting quick response to your issues:

www.sqlservercentral.com/articles/Best+Practices/61537/

-Lokesh

Save your time: Use the above script to find all nullable columns. Drop and recreate those columns.

They will all have NULL values ( no need to update) 🙂

No Worries. That happens - we are humans after all 🙂

And Thanks to you and Lynn for at-least criticizing my post. I am not very old to SSC, your support...

[His Post :-)]

Another example to clarify:

SELECT *

FROM table_name

WHERE DateOfIncidentDte >= '01-01-2012'

AND DateOfIncidentDte < '01-01-2013'

Hope, you agree with me now - Sean 🙂

My Friend, point here is that SQL Optimizer will not be able to use an index if the query is sargable. It will literally try to evaluate and match "DateOfIncidentDte"...

Please clarify - do you want a query that return top 25 sales of top 25 stores?

I will go with Sean, the best way is to un-do with dynamic SQL. If your code is not exposed and free from SQL Injections - convert your query as...

Other option is to explore SSIS..

In Feb, a similar post was raised, check the link:

http://www.sqlservercentral.com/Forums/Topic1255325-391-1.aspx

Might be of help.

Good question, but very easy options 🙂

To start with, please post some DDL and DML; example below

DDL

CREATE TABLE abc

( col1 INT NULL,

col2 CHAR(1) NULL,

....

)

Go

DML

INSERT INTO abc

VALUES

(1,'a',....),

(2,'b',....),

(3,'c',....),

.....

and don't forget to put the expected...

You are welcome Brandie 🙂

Try using VARCHAR(MAX) instead for VARCHAR(8000)

For details check this link: http://www.sqlservercentral.com/Forums/Topic647815-145-1.aspx

- Lokesh

Sorry, not getting your question completely. As per the scenario given by you(simplifying):

Table_1

[SpaceId] [MemberId] [AdSpaceName] [TotalBlocks] [PaymentType]

...

Runnable is fine...but your process is only stuck if it is blocked by some other SPID. If this is not the case then your query is working. Check the active...