T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to do bitwise operation between strings? Thanks.

  Is it too late to say Happy New Year? I want to say Happy New Year to every one in my first post in…

  halifaxdal

  6 replies

  13 years, 4 months ago

  By: drew.allen

• performance issue in retrieving data from a varbinary field

  I am trying to retrieve data from a varbinary field from a table which has about half a million rec…

  bhattacharjee.partha

  2 replies

  13 years, 4 months ago

  By: Jack Corbett

• how to convert multiple rows into (separte) columns in one row?

  Hi, I have two tables, one for Employees details and another for employee's family member details…

  rajeev_vandakar-782919

  6 replies

  13 years, 4 months ago

  By: Cadavre

• Problem with dynamic SQL and OPENROWSET

  Hi I'm having problems forming a working dynamic sql statement using openrowset. I know variables …

  cynthia 99229

  4 replies

  13 years, 4 months ago

  By: cynthia 99229

• Select two Level Data from Multiple tables

  I have four table with data below 1) CREATE TABLE role( [roleID] [uniqueidentifier] NOT NULL CONST…

  MuhammadShafiq

  2 replies

  13 years, 4 months ago

  By: Cadavre

• Find main row details as per the entry added

  Hi guys, I have a table object. It has multiple rows attached in tblRecords.jpg file. Now, I m edit…

  Sagar Sawant

  3 replies

  13 years, 5 months ago

  By: arr.nagaraj

• Yet another date (Newbie, be gentle)

  I have trolled through the date, business days etc searches and haven't really fond the solution fo…

  steven.n.rhodes

  6 replies

  13 years, 5 months ago

  By: steven.n.rhodes

• select month 12

  hi i'm sure this has been posted before but i'm not sure how to ask the questions so new topic... i…

  spin

  4 replies

  13 years, 5 months ago

  By: spin

• Update with except conditon

  I want to update a column in a table. I am using:- update table set column name =.... except (sub q…

  SkyBVI

  20 replies

  13 years, 5 months ago

  By: Phil Parkin

• Help with this UPDATE

  Hi All, i have this data: DECLARE @spotresource TABLE ( id_resource int,id_offer int ,cod_resource…

  xRafo

  4 replies

  13 years, 5 months ago

  By: xRafo

• Problem on insert into sql server 2005 table

  DDL for table Create table dbo.email_template ( ID int …

  Jpotucek

  3 replies

  13 years, 5 months ago

  By: Devendrakumar

• Problems with T-SQL Exec statement

  OK.. I have been banging my head on the wall for a week now and haven't been able to figure this ou…

  jdrintnt

  8 replies

  13 years, 5 months ago

  By: TheSQLGuru

• filter conditions based on condition..

  well its a bit confusing to say like i want to enable a condition based on a specific condition.. e…

  m4x

  4 replies

  13 years, 5 months ago

  By: m4x

• need to encrypt and store passwords and store in urser table

  Does sql server 2005 offer some sort of prepackaged encrtpion? Or should i just make my own and sto…

  Snargables

  16 replies

  13 years, 5 months ago

  By: MuhammadShafiq

• select Query Issue

  Hi all, here is my table data ID PID Name 1 0 Ad 2 0 Area 3 1 L…

  MuhammadShafiq

  18 replies

  13 years, 5 months ago

  By: MuhammadShafiq