SELECT name

,type_desc

,default_database_name

FROM sys.sql_logins

WHERE is_policy_checked = 0

??

Kwisatz78 (6/24/2010)

---

HI there can anyone enlighten me on what the following expression is doing?

ISNULL([NU SHA Code]) ? (@[User::SHACodeFilter] == "") : (@[User::SHACodeFilter] == "") || ([NU SHA Code] == @[User::SHACodeFilter])

Ii...

I read this question differently to the posters above me, so my solution is different.

From what I read, you want to copy the entire contents of table1 into table2, then...

*NOTE* I didn't write any of this.

Function 1

CREATE FUNCTION dbo.F_table_date (@FIRST_DATE DATETIME,

...

Hey, after recently answering this thread, I found the original one here so I thought I'd share how I solved it.

I've come across this before, but basically what you have...

DECLARE @table AS TABLE(

VARCHAR(10),

[SELECT] VARCHAR(10),

[UPDATE] VARCHAR(10),

[VARCHAR] VARCHAR(10))

DECLARE @cnt INT

--25 rows

SET @cnt=25

WHILE @cnt > 0

BEGIN

...

Should've posted your question in a new thread. Regardless. . . something like this?

--DECLARE AND SET VARIABLE

DECLARE @number AS BIGINT

SET...

Right, modified. Not too happy with it, but it works.

--First, lets build some test data

DECLARE @table TABLE(

data VARCHAR(20));

DECLARE @cnt INT

--2,500,000 rows

SET @cnt=2500000

WHILE @cnt > 0

BEGIN

...

--First, lets build some test data

DECLARE @table TABLE(

data VARCHAR(20));

DECLARE @cnt INT

--2,500,000 rows

SET @cnt=2500000

WHILE @cnt > 0

BEGIN

SET @cnt=@cnt - 1

...

--Lets create some test data

DECLARE @table AS TABLE(

Begin_Journey_Date DATETIME,

Container_Key INT IDENTITY)

INSERT INTO @table (Begin_Journey_Date)

SELECT '2010-01-01'

UNION ALL SELECT '2010-05-01'

UNION ALL SELECT...

omd (6/21/2010)

---

Hi,

I'm trying to add a value (that value being Y) to the...

First, lets build some test data.

DECLARE @shellorganisation AS TABLE(

org_name VARCHAR(50))

INSERT INTO @shellorganisation (org_name)

SELECT 'DO NOT USE ABCDE'

UNION ALL...

DECLARE @table AS TABLE(

k1 INT,

k2 INT,

k3 VARCHAR(2))

INSERT INTO @table (k1,k2,k3)

SELECT 17, 18, 'AA'

UNION ALL...

Well, lets see shall we? 😉

USE TestingDB

DECLARE @sqlcmd AS VARCHAR(4000)

DECLARE @theErrNbr AS VARCHAR(500)

CREATE TABLE table1 (

colA VARCHAR(50),

colB VARCHAR(50))

CREATE TABLE...

NicHopper (6/17/2010)

---

Hi,

Sorry I'd...