SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Problem with IIF in SSRS

  I have the following expression in my SSRS report: = IIf(IsNothing(Fields!Drop_Off_Time.Value), (Ti…

  ccamatthews

  1 replies

  14 years, 10 months ago

  By: DracoRaptorX

• Stores Procedure with Conditions based on a parameter

  I'm trying to have a condition like if @Type = 'TWO' then ColumnA LIKE N'%' + ' 20-' + N'%' else C…

  geoff 52196

  3 replies

  14 years, 10 months ago

  By: geoff 52196

• Simple Question about "Script Table as... INSERT To"

  I understand the structure of the INSERT INTO...VALUES. What i don't understand are the "<" and …

  Jacob Pressures

  2 replies

  14 years, 10 months ago

  By: GSquared

• Converting ASCII strings to the nvarchar characters they represent in SQL server 2008

  I recently had to replace ASCII strings in a table. Being a SQL server newbie, I struggled with wr…

  caspersql

  2 replies

  14 years, 10 months ago

  By: caspersql

• Help with a locking process involving extended stored procedures

  Hi, I have a problem on one of our SQL databases in that there is a locking process that is occurri…

  Chris Crowhurst

  3 replies

  14 years, 10 months ago

  By: Grant Fritchey

• Long running transactions

  Hi Team, i am very new to this forum.... we have SCOM R2 which monitors all our SQL servers which i…

  vrkumar01

  2 replies

  14 years, 10 months ago

  By: vrkumar01

• I need to use the variable in the oledb source

  Hi all, i have posted this in SSIS but did not get any reply so i am trying my luck here: I am crea…

  itskumar2004

  3 replies

  14 years, 10 months ago

  By: itskumar2004

• security parameters

  Hi, what is the use of set Nocount on while preparing scripts? Shovan

  mukherjee.shovan

  1 replies

  14 years, 10 months ago

  By: steveb.

• Read glolal settings of server vs Database

  HI.. I load my MSSQL 2005 database onto a shared hosting environment. My local server has default s…

  Digs

  1 replies

  14 years, 10 months ago

  By: Brandie Tarvin

• SQL Database monitor : How?

  HI, My client software is ASP.net 2.0 is on a SHARED sql server hoster provider. I use ADO to crea…

  Digs

  2 replies

  14 years, 11 months ago

  By: Digs

• SQL Server 2005 & Avast ADNM issues

  I am posting here as well as on the Avast forums, and am not sure if this is the right sub-forum to…

  tarn.alcock

  3 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• Help please

  I'm trying to use in a transformation But Also I'm trying to use the input data as a output. Import…

  ramossaucedo

  4 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• Help with SQL Query

  I'm a newbie, I need help with sql query. The requirement is : To get data from variable value whic…

  rtanda

  1 replies

  14 years, 11 months ago

  By: Gail Shaw

• Convert from XML to SQL tables and vice-versa using XSD schemas

  I want to compare the performance of running queries against data stored in XML format versus the s…

  ed_ward_graham

  4 replies

  14 years, 11 months ago

  By: ed_ward_graham

• Reporting the content of a memo field when a GROUPING is involved

  My query does a count and also needs to show content of a memo eg: SELECT ID, COUNT(Txt1) AS Tx…

  geoff 52196

  2 replies

  14 years, 11 months ago

  By: geoff 52196