BJ (10/30/2008)

---

Hi,

I have a application running with sql 2000 database. We were redesigning the application and decided to move to sql 2005. We designed a new front end architecture and...

cmosentine (10/30/2008)

---

Hi all: We are looking at upgrading our SQL 2005 server's OS from 2003 R2 (64-bit) to 2008 (64-bit). The server only has two functions, albeit important...

NP 😀

That time stamp represents 08/31/2008 🙂 It is...

brad (10/29/2008)

---

HI

I'm having issues with unzipping files via xp_cmdshell and bulk inserting into a table. Occasionally these zip files have CRC errors, and this causes havoc when inserting to the...

garethmann101 (10/29/2008)

---

I have a set of tables with 4 identical fields. I need to have the data for all tables merged into a single table, note this is NOT a...

m.berggren (10/29/2008)

---

I actually got this to work. But i´m sure I can optimize or write the code in a different way. I didn´t got the (2) INSERT to work so...

Mike (10/28/2008)

---

I'm writing a query that is allowing the user from my web page to do a search with selecting parameters and a date parameter is one of them...

m.berggren (10/28/2008)

---

Hi,

I have a little question. I have imported data from a csv file. Here are 4 values. These are imported to an temporary table.

CREATE TABLE custom.mi_def_tmp (

mi_seq INT PRIMARY...

andre_gonv (10/28/2008)

---

Hi

i have this table whit data:

Codigo Titulo de Libro ...

latingntlman (10/28/2008)

---

Thanks Tommy, it works!! Now, what if I need to see results for more than one table by executing the temp sproc only once? i.e.

Exec...

glee33 (10/20/2008)

---

I installed SQL Server 2008 successfully on my XP system last week but now an annoying "black box" appears on the screen. It looks like a command prompt...

You could always create a static table in TempDB as well....i.e.

create table tempdb..blah

(

id int not null,

somecolumn char(10)

)

Then drop the table when you are finished with it. As already...

srawant (10/27/2008)

---

Hi guys,

I have different environment with the same replication setup. I am trying to create a stored procedure to check the replicated tables of the publisher matches with subscriber(...

latingntlman (10/27/2008)

---

Tommy,

Thanks for the headsup. However, in sql 2005, I executed the sproc as exec #TSQL_Search 'ReportProcessing' (ReportProcessing being the Db) where there are a bunch of sprocs but...